session_start();
include_once("functions.php");
//print_r($_SESSION);
if($_SERVER['REQUEST_METHOD']=="POST"){
if(isset($_POST['log']) && $_POST['log']=='log'){
$qur1=mysql_query("select * from auto_users where username='".$_POST['logname']."' and password='".$_POST['logpass']."'");
$cnt=mysql_num_rows($qur1);
$row=mysql_fetch_array($qur1);
if($cnt==0){
$errmsg="Invalid user";
} else {
/*session_unregister("user_logname");
session_unregister("temp_uid");
session_unregister("temp_name");
session_register("user_logname");
session_register("temp_uid");
session_register("temp_name");*/
$_SESSION['user_logname']=$_POST['logname'];
$_SESSION['temp_uid']=$row['id'];
$_SESSION['temp_name']=$row['name'];
if(isset($_SESSION['ref_id'])){
mysql_query("update temporders set userid=".$row['id']." where ref_id='".$_SESSION['ref_id']."'");
}
echo "";
}
} else if(isset($_POST['search_form']) && $_POST['search_form']=='search_form'){
$qry="SELECT * from accessory as a,acc_vehicle as v where a.aid=v.acc_id_fk and v.MAKE_ID_FK='".$_POST['make']."' and v.MAKE_MODEL_ID_FK='".$_POST['model']."' and VEH_ID_FK='".$_POST['year']."'" ;
$res=mysql_query($qry);
$tot=mysql_num_rows($res);
/*session_unregister("make");
session_register("make");*/
$_SESSION['make']=$_POST['make'];
/*session_unregister("model");
session_register("model");*/
$_SESSION['model']=$_POST['model'];
/*session_unregister("year");
session_register("year");*/
$_SESSION['year']=$_POST['year'];
/*session_unregister("submodel");
session_register("submodel");*/
$_SESSION['submodel']=$_POST['submodel'];
if($tot>0) {
echo "";
} else{
echo "";
}
}
}
if(!empty($_GET['msg'])=='ch'){
/*session_unregister("make");
session_register("make");
session_unregister("model");
session_register("model");
session_unregister("year");
session_register("year");
session_unregister("submodel");
session_register("submodel");
session_unregister("makesearch");
session_register("makesearch");*/
}
?>
$c=array('images/acura-mid-big-final.jpg','images/chevy-mid-big-final.jpg','images/dodge-mid-big-final.jpg','images/ford-mid-big-final.jpg','images/gmc--mid-big-final.jpg','images/honda-mid-big-final.jpg','images/hummer-mid-big-final.jpg','images/jeep-mid-big-final.jpg','images/nissan-mid-big-final.jpg','images/toyota-fj-mid-big-final.jpg','images/toyota-mid-big-final.jpg');
//shuffle($c);
//print_r($c);
//echo " ";
//print_r($c);echo " ";ksort($c);print_r($c);
?>
$s="select * from cities where CityId='".$_GET['cid']."'";
$r=mysql_query($s);
$roe=mysql_fetch_array($r);
?>
echo $roe['City']?>
include("head.php")?>
$s="select * from cities as c,regions as r where r.RegionID=c.RegionID and c.CityId='".$_GET['cid']."'";
$r=mysql_query($s);
$roe=mysql_fetch_array($r);
?>
$acc_qry=mysql_query("select * from categories where status=1"); ///query for displaying left side categories
$cnt=mysql_num_rows($acc_qry);
while($accrow=mysql_fetch_array($acc_qry)){
$cnt=getdata("products","count(*)","cat_id=".$accrow['id']); if($cnt>0){
?>
echo $accrow['catname']?>
$selqur=mysql_query("select * from products where cat_id='".$accrow['id']."' and prstatus='1' group by prname"); ////query for displaying left side product names under categories
while($sel_row=mysql_fetch_array($selqur)){
?>
$s="select * from cities where CityId='".$_GET['cid']."'";
$r=mysql_query($s);
$roe=mysql_fetch_array($r);
?>
echo $roe['City']?> Auto & Truck Accessories
echo $roe['city_largedesc']?>
//$cnt=getdata("accessory","count(*)","prstatus=1 and cat_id=1");
$squery="select * from regions order by Region asc";
$sres=mysql_query($squery);
$scount=mysql_num_rows($sres);
if($scount>0) {
?>