I get the following error: 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 'RETURN ( RETURN_ID INT(12) NOT NULL AUTO_INCREMENT, RETURN_RENTAL_ID I' at line 1

I am trying for 3 hours now to find what the problem is... I have checked everything, all about the foreign keys I use etc, but nothing seems to work... I can't see what my syntax error is... Any help is greatly appreciated...

eelixduppy

5:39 pm on Feb 3, 2007 (gmt 0)

RETURN

is a reserved word [dev.mysql.com] in MySQL. You must surround it with the prime symbol to escape it! (`). An example:

...CREATE TABLE IF NOT EXISTS `RETURN`(...

Generally it is not encouraged to use names that are the same as a reserved word. You might want to think about changing the name of the table.