PHP and MySQL quantity updating

[mayakovski]

Hello;<br>I'm new to PHP and MySQL but fumbling through it.&nbsp;&nbsp;I have a question though.&nbsp;&nbsp;I am putting together an online store using PHP4 and MySQL, but I am having trouble in figuring out how to update inventory quantities in the database.<br>I have looked at a number of PHP4 database scripts and non of them use a product quantity in the database that gets adjusted as users add to there carts.&nbsp;&nbsp;Any thoughts on how I can do this?&nbsp;&nbsp;I want the database to automatically be updated when products are purchased.

 

[ElgisRamon]

I gues you must use something like:<br><FONT FACE=monospace><br>$retcode = mysql( $database, &quot;UPDATE invent SET quant=quant+something WHERE condition&quot;, $conex );<br></font><br><br>I hope it works...