Mario
|
| Posted: 02/13/2003, 5:13 AM |
|
When building an SQL queries CCS don't enclose column names into a back single quotes (`). Then, if table has a column named Order or Select, PHP script generated was crashes  ((
|
|
|
 |
RonB
|
| Posted: 02/13/2003, 6:26 AM |
|
I don't know if this is a shortcomming. The mysql manual clearly states a list of reserved words. I think it's a good designing practice not to use these words as table or field names. To correct the problem all you have to do is add a prefix. Like client_order, supplier_order. This also ensures you will not run into trouble with fieldnames being identical when you have to join tables.
client order has cl_order_id and supplier_order has supp_order_id.
Ron
|
|
|
|
|
