Hello all, I have an arcade site that until this morning was working flawlessly. Since 10 am, every time I try to play a game in my site, it throws me a SQL Query error Query: SELECT * FROM games WHERE cat=\'Rompecabezas\' AND id!=\'1006\' ORDER BY RAND() DESC LIMIT 0, 9 Code (markup): I noticed that this sql query is always going to give an error because of the backslashes, but as the query is created dinamically, I don't know if I have to make modifications in the php file that calls the query, or in the databse itself. Any help would be greatly appreciated. AL
You can't remove the slashes from the DB so you will have to do it in the script after collecting from the DB using stripslashes($string); Thanks
Yes, somehow it started working again like an hour ago. Still, I would like to understand what happened before, it's strange that in some periods of time it would give a sql error, and then just disappear. Doing some research on the web, found that the probable cause is the backslashes in the query, but still, haven't got a clue on how to optimize the queries in the script.
Today I have the same SQL Query problem, any ideas on what may be causing it or how to fix it. Thanks in advance