here is my problem
when my page tries to pull nextid i get the error
<b>Database error: Invalid SQL: lock tables db_sequence write
MySQL Error: 1044 (Access denied for user: 'claeve_1@%' to database 'claeve_db1')
Session halted.</b>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
here is my problem
when my page tries to pull nextid i get the error
<b>Database error: Invalid SQL: lock tables db_sequence write
MySQL Error: 1044 (Access denied for user: 'claeve_1@%' to database 'claeve_db1')
Session halted.</b>
Since mysql 4.02 you have to have the global lock table privilege granted.
" As of MySQL 4.0.2, to use LOCK TABLES you must have the LOCK TABLES privilege and a SELECT privilege for the involved tables. "
http://dev.mysql.com/doc/mysql/en/lock-tables.html
Thank you, i will try it