0){ $myrow = mysql_fetch_array($result); $category_name = $myrow['name']; } } $sql = "SELECT id, name, photo1 FROM products "; if ($_REQUEST['id']){ $sql .= " WHERE category = '" . $_REQUEST['id'] . "'"; $sql .= " AND (type = 'Slab' OR type = 'Both') "; $sql .= "ORDER BY list_order ASC, name ASC"; }else{ $sql .= "ORDER BY name ASC"; } $category_images = array( '2'=>'marble.jpg', '4'=>'granite.jpg', '6'=>'limestone.jpg', '5'=>'travertine.jpg', '7'=>'onyx.jpg', '8'=>'quartz.jpg', '9'=>'slate.jpg', '10'=>'mosaics.jpg', '3'=>'porcelain.jpg', ); $page_data = GeneratePageLinks($sql, 10000, 10, $pagenumber); ?> TriStone & Tile – Leader in high-end, imported stone.