session_start(); require_once('myconnect.php'); require_once('check_runner.php'); if(isset($_COOKIE['member'])) $_SESSION['member'] = $_COOKIE['member']; if(isset($_COOKIE['username'])) $_SESSION['username'] = $_COOKIE['username']; if(isset($_SESSION['member'])){ $WelcomeNote = "Welcome $_SESSION[member]"; }else{ $WelcomeNote = ""; } mysql_query("DELETE FROM shoppingcart WHERE SysDate < CURDATE();"); mysql_query("DELETE FROM orders WHERE (((orders.SysDate) < CURDATE()) AND ((orders.Flag)=0));"); $Manue_Recordset1 = mysql_query("SELECT sub_category.CategoryName, sub_category.ID as scid, sub_category.MCID as cid FROM main_category INNER JOIN sub_category ON main_category.ID = sub_category.MCID WHERE (((sub_category.MCID)=1)) ORDER BY sub_category.CategoryName;") or die(mysql_error()); $row_Manue = mysql_fetch_assoc($Manue_Recordset1); $Manue_Recordset2 = mysql_query("SELECT sub_category.CategoryName, sub_category.ID as scid, sub_category.MCID as cid FROM main_category INNER JOIN sub_category ON main_category.ID = sub_category.MCID WHERE (((sub_category.MCID)=2)) ORDER BY sub_category.CategoryName;") or die(mysql_error()); $row_Manue2 = mysql_fetch_assoc($Manue_Recordset2); $Manue_Recordset3 = mysql_query("SELECT sub_category.CategoryName, sub_category.ID as scid, sub_category.MCID as cid FROM main_category INNER JOIN sub_category ON main_category.ID = sub_category.MCID WHERE (((sub_category.MCID)=3)) ORDER BY sub_category.CategoryName;") or die(mysql_error()); $row_Manue3 = mysql_fetch_assoc($Manue_Recordset3); $Manue_Recordset4 = mysql_query("SELECT sub_category.CategoryName, sub_category.ID as scid, sub_category.MCID as cid FROM main_category INNER JOIN sub_category ON main_category.ID = sub_category.MCID WHERE (((sub_category.MCID)=4)) ORDER BY sub_category.CategoryName;") or die(mysql_error()); $row_Manue4 = mysql_fetch_assoc($Manue_Recordset4); $Manue_Recordset5 = mysql_query("SELECT sub_category.CategoryName, sub_category.ID as scid, sub_category.MCID as cid FROM main_category INNER JOIN sub_category ON main_category.ID = sub_category.MCID WHERE (((sub_category.MCID)=5)) ORDER BY sub_category.CategoryName;") or die(mysql_error()); $row_Manue5 = mysql_fetch_assoc($Manue_Recordset5); ?>
|
||||||||||||||||
| My Account | Logout | Login | Register Home | About us | Prices | Services | Security / Privacy | Contact Us | Help |
||||||||||||||||