RE: [PHP-DB] Weird query and display issue

Hi All, Got this working with help from another over at devshed.com $query = "SELECT * FROM CartTable WHERE cart_id='$ID' AND company='$company' AND (product_index='1' OR product_index='2' OR product_index='3')"; $result = mysql_query($query); while($cartResult = mysql_fetch_array($result)) { if ($cartResult["name"] == "Baseball Hitting Aid" || $cartResult[name] == "Tennis Training Aid") { $products["Practice Hit"]+=$cartResult["quantity"]; } if ($cartResult["name"] == "Golf Swing Trainer") { $products["Swing Lock"]+=$cartResult["quantity"]; } } foreach($products as $product => $quantity) { echo $quantity." ".$product; } Thanks for all who took the time to provide insight. Aaron -----Original Message----- From: Matt King [mailto:php@magnetinternet.com] Sent: May 7, 2003 11:52 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Weird query and display issue Aaron Wolski wrote: > The following code is displaying 3 results when it SHOULD only be > displaying 1 result (I know it should be one because only one product > was selected to be ordered). Are you sure there aren't isn't than one result? What does mysql_num_rows($result) return? > $allrows[] = $cartResult; This doesn't make any sense to me...why are you doing this? Then you are iterating through it at the bottom. So if there are 3 things printing, there must be 3 things in this array...check your rows returned. -- Matt King magnet | internet http://www.magnetinternet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php