1064 Error in displaying MYSQL data after creating custom table

[qwerpoiu338]

Greetings. Tried to display a few fields in blank sidebox. Added new table in database and defined it in database_tables.php.
It returned with the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' . TABLE_NEW . ' ORDER by field1' at line 2
in:
[SELECT field1, field2' . TABLE_NEW . ' ORDER by field1]

Currently running with PHP 5.2.5; MYSQL 4.1.22;

Does this mean I need to upgrade MYSQL?

[kuroi]

No, it's not a MySQL versioning issue. It's about declarations and syntax.

Three issues to be dealt with:

1. The table name hasn't been properly included in a "define" statement which is why it isn't getting resolved into a proper table name. You would normally include a statement in an extra_datafiles/your_datafile_name.php of the form define('TABLE_NEW', 'newtablename'); so that Zen Cart knows to which table TABLE_NEW refers
2. You would need a space at the end of the string immediately before the constant is inserted to avoiud them running together when the constant is resolved
3. You also need a "from" before the table name to indicate that you have finished your field list and are moving onto your tables

[qwerpoiu338]

Thank you. Will give it a try.