include("objects/login/info.php"); include("get_material_title.php"); require_once('objects/includes/functions_inc.php'); session_start(); ?>
$selector_type = $_GET['type']; $page_error = $_POST['error']; if($selector_type == 'furniture'){ echo ""; $page_color = "green"; $new_item_image = "objects/images/item/item_new_green.png"; } if($selector_type == 'accessories'){ echo ""; $page_color = "amber"; $new_item_image = "objects/images/item/item_new_amber.png"; } if($selector_type == 'miniboom'){ echo ""; $page_color = "blue"; $new_item_image = "objects/images/item/item_new_blue.png"; }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); $prod_id = urldecode($_GET['id']); $item_query= "SELECT * FROM products WHERE sku1='$prod_id'"; $item_result=mysql_query($item_query); $query2="SELECT * FROM weekly_special"; $result2=mysql_query($query2); /*ITEM VARIABLES*/ $set_of =mysql_result($item_result,0,"set_of"); $item_title =mysql_result($item_result,0,"title"); $item_price =mysql_result($item_result,0,"price"); $item_material =mysql_result($item_result,0,"material"); $sku2 =mysql_result($item_result,0,"sku2"); $item_description=mysql_result($item_result,0,"description"); $sub_cat=mysql_result($item_result,0,"category_3"); $item_standard_size =mysql_result($item_result,0,"size"); $item_small_size =mysql_result($item_result,0,"small_size"); $item_medium_size =mysql_result($item_result,0,"medium_size"); $item_large_size =mysql_result($item_result,0,"large_size"); $item_xlarge_size =mysql_result($item_result,0,"xlarge_size"); $item_is_new =mysql_result($item_result,0,"is_new"); $item_description =mysql_result($item_result,0,"description"); /*ITEM VARIABLES*/ $query3="SELECT * FROM products WHERE category_3='$sub_cat'"; $relevant_result=mysql_query($query3); $num=mysql_numrows($relevant_result); mysql_close(); /*$item_image ="objects/images/product_images/".$prod_id.".png";*/ /******IF IMAGE DOES NOT EXIST, LOAD ERROR TILE ************/ if($img = @GetImageSize("objects/images/product_images/$prod_id.png")) { $item_image="objects/images/product_images/$prod_id.png"; } else { $item_image='objects/images/product_images/image_not_available.gif'; } /****************************************/ $go_back = $_SERVER['HTTP_REFERER']; /*******************/ /*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"); /******************/ /* PHP SPLIT FUNCTION FOR