Results 1 to 1 of 1
Mar 14, 2006, 08:35 #1
IGNORE - fixed - LAST_INSERT_ID() not working?
No problem here - I forgot I needed the semi-colons after each query in the phpMyAdmin query window to stop MySQL bawlking at multiple queries at a time - now "fixed".
I have a couple of INSERT SQL queries which look like this:
INSERT INTO reviews_table (id, live, make, model, reviewer, review) VALUES (NULL, 0, 1, 45, 2, 'Test Review') INSERT INTO ratings_table (make, model, rating, review) VALUES (1, 45, 8, LAST_INSERT_ID())
#1064 - You have an error in your SQL syntax