$stat = "retail"; //enter product names as they appear on page. $product_name[] = "Great Grabz Safety Bars"; $product_name[] = "EZ-Light House Numbers"; //enter item numbers of lowest price for each above in same order as above. $item[] = "HS-GG-H10-PB"; $item[] = "LTLED-EZLIGHT"; //enter catalog link for products above in same order. $link[] = "cathomesafe1.php"; $link[] = "catlite13special.php?fr=hs"; //enter thumbnail image url (relative) $img[] = "images/cathomesafe1_1thmb.jpg"; $img[] = "images/catlite13thmb.jpg"; //enter next & back category page $next = "catecohouseplans.php"; $back = "catappspecial.php"; ///////////////////////////////// $dbcnx = new mysqli('localhost', 'ecoszzqh_produser', 'cata1og', 'ecoszzqh_products'); foreach($item as $value){ $result = $dbcnx->query("SELECT list,$stat FROM price WHERE item = '$value'"); if(!$result){ $mess[] = "Could not get price for $value. Error: ".mysql_error(); } $row = $result->fetch_row(); $list_price[] = $row[0]; $price[] = $row[1]; }//4each ?>
Home Safety
$i = 0; $prodcount = count($item); while($i < $prodcount){ echo("
" . "
" . "
" . "
$product_name[$i]
"); echo("
QUOTED
"); echo("
"); $i = $i + 1; }//while ?>