screen resolution stats
'; echo ""; $cat_id = $_GET['cat']; if ( $cat_id == 'all' ) { $query_string = "SELECT * FROM products WHERE category_1='f'"; } else { $query_string = "SELECT * FROM products WHERE category_1='f' AND category_2='$cat_id'"; } } if($selector_type == 'accessories'){ echo ''; echo ""; $cat_id = $_GET['cat']; if ( $cat_id == 'all' ) { $query_string = "SELECT * FROM products WHERE category_1='a'"; } else { $query_string = "SELECT * FROM products WHERE category_1='a' AND category_2='$cat_id'"; } } if($selector_type == 'miniboom'){ echo ''; echo ""; $cat_id = $_GET['cat']; if ( $cat_id == 'all' ) { $query_string = "SELECT * FROM products WHERE category_1='m'"; } else { $query_string = "SELECT * FROM products WHERE category_1='m' AND category_2='$cat_id'"; } } if($selector_type == 'sale'){ echo ''; echo ""; $query_string = "SELECT * FROM products WHERE is_new = 'SALE'"; } else{ } mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $contact_query="SELECT * FROM contact_info"; $contact_result=mysql_query($contact_query); $cat_query=$query_string; $cat_result=mysql_query($cat_query); $query2="SELECT * FROM weekly_special"; $result2=mysql_query($query2); mysql_close(); $num=mysql_numrows($cat_result); /*CONTACT VARIABLES*/ $title=mysql_result($contact_result,0,"boom_title"); $address1=mysql_result($contact_result,0,"address1"); $address2=mysql_result($contact_result,0,"address2"); $phone=mysql_result($contact_result,0,"phone"); $fax=mysql_result($contact_result,0,"fax"); /*******************/ /*SPECIAL VARIABLES*/ $special_type=mysql_result($result2,0,"type"); $special_id=mysql_result($result2,0,"sku1"); $special_title=mysql_result($result2,0,"title"); $special_description=mysql_result($result2,0,"description"); $special_price=mysql_result($result2,0,"price"); /******************/ ?> View <? echo $selector_type.' / '.$cat_id?>
All Furniture'; } if($selector_type == 'accessories'){ echo 'All Accessories'; } if($selector_type == 'miniboom'){ echo 'All Miniboom'; } ?>

'.urldecode($item_title).'
'; $i++; } ?>