ok so im trying to alter the code ive got so that instead of 'deleting' some thing from the records you also get some money back
at the moment im just trying to get back the total cost of the items im selecting so that i can process it and then add it to money however it doesnt seem to be working
the stats are all in a database
the most ive got to so far is it always shows 'drugs' and 10000
oh almost forgot the code
CODE
$qryq = mysql_query("select item from items where itemid = '".$id."'") or die(mysql_error());
while($qryqresult = mysql_fetch_array( $qryq )){
$itema[] = $qryqresult['item'];
$itemarray = implode(",", $itema);
echo $itemarray;
$qeuryitem = mysql_query("select moneyexcellent from itemstats where item = '".$itemarray."'") or die(mysql_error());
while($queryitemselect = mysql_fetch_array($qeuryitem)){
$itemcost[] = $queryitemselect['moneyexcellent'];
$itemstring = implode(",", $itemcost);
echo $itemstring;
}
}
| 