smsmasters
10-01-2006, 12:45 PM
I get a database error similar to this whenever the .zip file has an ' in the file name.
mySQL query error: SELECT gid, gname FROM games_list WHERE gname='Gandy's Quest (Dechevious)'
mySQL 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 's Quest (Dechevious)'' at line 1
mySQL error code:
Date: Sunday 01st 2006f October 2006 02:41:20 PM
If you remove the ' the error is gone.
mySQL query error: SELECT gid, gname FROM games_list WHERE gname='Gandy's Quest (Dechevious)'
mySQL 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 's Quest (Dechevious)'' at line 1
mySQL error code:
Date: Sunday 01st 2006f October 2006 02:41:20 PM
If you remove the ' the error is gone.