JeevesBond — Sat, 03 Feb 2007 22:37:46 +0000

Try this:

mysql_query ("CREATE TABLE IF NOT EXISTS `RETURN` (
RETURN_ID INT(12) NOT NULL AUTO_INCREMENT,
RETURN_RENTAL_ID INT(12) NOT NULL,
RETURN_COPY_ID INT(12) NOT NULL,
RETURN_MOVIE_ID INT(12) NOT NULL,
RETURN_DATE DATE NOT NULL,
PRIMARY KEY (RETURN_ID),
CONSTRAINT RETURN_IBFK_1 FOREIGN KEY(RETURN_RENTAL_ID) REFERENCES RENTAL(RENTAL_ID),
CONSTRAINT RETURN_IBFK_2 FOREIGN KEY(RETURN_COPY_ID) REFERENCES COPY(COPY_ID),
CONSTRAINT RETURN_IBFK_3 FOREIGN KEY(RETURN_MOVIE_ID) REFERENCES MOVIE(MOVIE_ID))"
) || die(mysql_error());

A cut-down version of that just worked for me on my local MySQL.

EDIT: It doesn't seem to like 'RETURN' being the table name, without the backticks ``. This is probably because 'RETURN' is a reserved word. It's used as part of MySQLs language (stored procedures/user defined functions) so it gets confused when you start calling a table by that name!

It's generally good practice to either name things so they won't cause a problem, e.g. APPNAME_RETURNS, or put backticks around all your names, or you could do both!