Hello all. Can I reset a query after it's been used in a loop. How would I reset the following loop after it has already been used in a loop??
$getallocated=SELECT nsidetails.quantity, sum( nsidetails.quantity ) AS 'allocatedsum'
FROM nsidetails
WHERE nsidetails.equipmentid = '$line[equipmentid]' AND nsidetails.itemstatus = 'IN STOCK'
GROUP BY nsidetails.equipmentid";
$getallocatedresult=mysql_query($getallocated, $link);
$getallocatedline=mysql_fetch_array($getallocatedresult, MYSQL_ASSOC);
