[RESOLVED] mysql: add given # to stored #

[scrupul0us]

can i get a basic example of how i would add a number (given by the user) to an existing stored value in mysql:

UPDATE inventory SET invSTOCK=$invADD+<stored value here> WHERE code=$invCODE LIMIT 1

[bradgrafelman]

UPDATE inventory SET invSTOCK = invSTOCK + 5 WHERE code=123 LIMIT 1

[scrupul0us]

im getting an unexpected T_VARIABLE now:

mysql_query("UPDATE inventory SET invSTOCK = invSTOCK + ".$value." WHERE invCODE=."$key". LIMIT 1") or DIE (mysql_error());

[bradgrafelman]

You've got your periods and quotes switched around at the $key reference.

[scrupul0us]

ok... getting another error:

"UPDATE inventory SET invSTOCK = invSTOCK + ".$value." WHERE invCODE=".$key." LIMIT 1"

UPDATE inventory SET invSTOCK = invSTOCK + 10 WHERE invCODE=38207A LIMIT 1

Unknown column '38207A' in 'where clause'

...but the column name is invCODE...

[bradgrafelman]

Ah, well, I just assumed invCODE was a numeric column. Since it actually stores strings, you need to specify a string, meaning you need to surround the data in quotes (invCODE='38207A').

[scrupul0us]

excellant!... everything is smooth sailing now... much obliged for the help 🙂

[bradgrafelman]

Glad I could help. Don't forget to mark this thread resolved.