| SQL Error
I have received these emails reporting SQL errors. Please help ...
Email, error 1:
An error was encountered during execution of the query:
INSERT INTO pp_users (userid,solditems) values(,1)
The query returned with an errorcode of:
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 '1)' at line 1
Email, error 2:
An error was encountered during execution of the query:
UPDATE pp_stats SET amt_sold=(amt_sold+), ads_sold=(ads_sold+1) WHERE id=1
The query returned with an errorcode of:
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 '), ads_sold=(ads_sold+1) WHERE id=1' at line 1
Email, error 3:
An error was encountered during execution of the query:
SELECT solditems FROM pp_users WHERE userid= LIMIT 1
The query returned with an errorcode of:
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 'LIMIT 1' at line 1
|