SQL Error

[prodigy]

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

[Chuck S]

number 1

This is in editproduct and is tied in with number 3 below

Content visible to verified customers only.

number 2

I dont see an issue here unless the price is empty in your classifieds table

$query = "UPDATE {$Globals['pp_db_prefix']}stats SET amt_sold=(amt_sold+$curprice), ads_sold=(ads_sold+1) WHERE id=1";

number 3

I again dont see how you would get an error unless the userid was empty for this product. This is in editproduct.php and here is the code. I have bolded the userid so it is there.

Content visible to verified customers only.

I guess one suggestion I would make would be to encapsulate in the queries $thisuser to say '$thisuser' so it does not throw an error in email but I wonder why the userid variable coming from the database would be EMPTY. You follow me here. Most of the errors your reporting is we grab the userid from the database for the product in question and issue an UPDATE OR INSERT on the variables we define from the query.