Mysql Multiple querys

Question

im currently running multiple mysql querys but want to just run one and loop through it. how can i improve this

$query = mysql_query("SELECT productid, code, size, quantity, sizechart, rprice, price, weight FROM inventory WHERE code = '$productcode1'"); 
 while ($rows1 = mysql_fetch_array($query))
 { 
 $productids1 = $rows1['productid']; 
 $codes1 = $rows1['code']; 
 $sizes1 = ucwords($rows1['size']); 
 $quantitys1 = $rows1['quantity']; 
 $sizechart = $rows1['sizechart']; 
 $rprice = $rows1['rprice']; 
 $sprice = $rows1['price']; 
 $dweight = $rows1['weight']; 
 } 

each query then carrys on the same, but $productcode2 and $productcode3 etc.

Answer 1

... WHERE code IN ('$productcode1','$productcode2',...)

Answer 2

Change "Where code = '$prouctcode1'" on "where code IN (...)"

Answer 3

One solution would be using PDO's prepared statements.

Quick, untested and dirty example based on PHP reference:

$stmt = $dbh->prepare("SELECT productid, code, size, quantity, sizechart, rprice, price, weight FROM inventory WHERE code = :code");
$stmt->bindParam(':code', $code);

foreach ($productCodes as $code) {
  $stmt->execute();
  $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
  // Do something with the results
}

Answer 4

thanks for the help. managed to get want i wanted with an array from the first query.