Keep getting mySQL error No. 1064, but i can't seem to find the problem
View Single Post
04-10-2008, 01:50 PM
Join Date: Apr 2008
Originally Posted by
The standard MySQL library can only have one statement at a time. You're trying to use four UPDATE statements with a single call to mysql_query. In this case, you can manipulate the query (the WHERE clause) into just one statement since all of the rows to be updated will be given the same new date value.
Found that out, remade the PHP function so it it splits up the statement and then use a while loop to get all the statements into the DB.
Thanks to all people for trying to help
View Public Profile
Send a private message to Durux
Find More Posts by Durux