mysql error 1064

[Arsenik]

Where can i find a list of error code and what they mean?

I integrated a script with vb and used vb's DB class.

I want to LOCK a table while i update records in it.

I tried this:...
$DB_site->query("LOCK TABLES mytable_$table[tablenumber]");
...
And i get this error message:
...
Invalid SQL: LOCK TABLES mytable_1
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
...
What is the problem? Cant we LOCK tables using vb's DB class?

[filburt1]

You have to use plurality; i.e., LOCK TABLES mytable_whatever.

[Arsenik]

Corrected and still the same error. :cry: