[RESOLVED] Explain this code please

[pally]

Can anyone explain to me what this peice of code does please

thank you

$carray = mysql_fetch_array(mysql_query('SELECT quantity FROM products WHERE productid = '.$carttemp_prodid.' LIMIT 10')); // excute the query 
$nquan = $carray['quantity']-$carttemp_quan;

[sneakyimp]

it fetches a value from a database and subtracts $carttemp_quan from it and puts that value in $nquan

[pally]

thanks alot...could you tell me abit about the LIMIT 10?

[bradgrafelman]

Yep. Look at MySQL's manual: http://dev.mysql.com/doc/refman/5.0/en/select.html#id3049947

[sneakyimp]

LIMIT 10 limits the number of records retrieved to 10. given that the code is only fetching values from the query once, only the first record is going to be used.