/* Project Name : imoxie.com Program name : product_details.php Program function : page for product details Author : Aneeshlal Developed by : colbridge Created Date : 2 nov 2007 Update History ------------------------------------------------------------------- Date By short desc. of what updated 16 nov 07 Rajmohan R Listing of product attributes 19 nov 07 kabeer updated display & attribute section -------------------------------------------------------------------*/ session_start(); $member_id=$_SESSION['session_member_id']; include("./include/global.php"); $product_id=$_REQUEST['product']; $redirect = $_REQUEST[redirect]; $pres = $_REQUEST[pres]; $width=151; $height=134; if(isset($_REQUEST[btn_submit])) { $attribute_alert=0; $product_id=$_REQUEST['product_id']; $catego= $_REQUEST['cat']; $redirect = $_REQUEST['redirect']; $pres = $_REQUEST['pres']; $att=$_REQUEST['att']; for($k=0;$k<$att;$k++) { $inside="sel_$k"; $att_drop_value=$_REQUEST[$inside]; // $a.=$att_drop_value.","; if($att_drop_value != 0){ $sql_parent_id="select * from tbl_attribute_value where int_attribute_value_id=$att_drop_value"; $rs_parent_id= mysql_query($sql_parent_id); // if(mysql_num_rows($sql_parent_id)>0){ $attr_parent_id=mysql_result($rs_parent_id,0,int_attribute_id); $pipe=$attr_parent_id."|".$att_drop_value; $pipe_new.=$pipe.","; } } if($pipe_new==""){ $attribute_alert=1; }else{ header("location:./act_order.php?pipe=$pipe_new&product_id=$product_id&cat_id=$catego&redirect=$redirect&pres=$pres"); exit; } } if(isset($member_id) and $member_id!=""){ $sql_cust="select * from tbl_customer where int_customer_id=$member_id"; $rs_cust=mysql_query($sql_cust); if(mysql_num_rows($rs_cust)>0){ $bit_request_send=mysql_result($rs_cust,0,bit_request_send); } } $sq = "select * from tbl_product where int_product_id=$product_id"; $res=mysql_query($sq); if(mysql_num_rows($res)>0){ $title = mysql_result($res,0,str_title); $keyword = mysql_result($res,0,$keyword); $description = mysql_result($res,0,txt_metatag_description); } include("./header.php"); $catego= $_REQUEST['cat']; $sql = "select * from tbl_product order by str_product_name ASC"; //Query to fetch all the Products $result = mysql_query($sql); $attr_check=mysql_query("select * from tbl_product_attribute where int_product_id='$product_id' "); $attr_set=mysql_num_rows($attr_check); ?>