|
echo $brand ; ?> |
$m=0 ;
$n=20 ;
$brand = $_GET["brand"] ;
$model = $_GET["model"] ;
$year1 = $_GET["year1"] ;
$year2 = $_GET["year2"] ;
$cat = $_GET["cat"] ;
include("userpass.php3");
mysql_connect ($host, $users, $password) or die ("File not found");
mysql_select_db ($database);
$resultz = mysql_db_query ($database, "select * from model where (brand= '$brand') and (model= '$model')")or die(mysql_error());
$rowz = mysql_fetch_array ($resultz);
?>
|
|
$chk = mysql_free_result($resultz);
mysql_close;
?>
|
|
|
Brand : echo $brand;?> Model1 : echo $model;?>
if($year1){?>Year : echo $year1;?> if($year2){?>- echo $year2; ?> }}?> |
|
|
|
$result = mysql_db_query ($database, "select * from part where (cat='$cat') and (brand='$brand') and (model='$model') and (year1='$year1') order by code limit $m,$n") or die(mysql_error());
$results = mysql_db_query ($database, "select * from part where (cat='$cat') and (brand='$brand') and (model='$model') and (year1='$year1') ") or die(mysql_error());
$num = mysql_num_rows($results);
while ($row = mysql_fetch_array ($result)) {
?>
|
|
|
|
|
$row = mysql_fetch_array ($result);
if($row['model']){
?>
|
|
|
|
}
?>
|
|
|
|
}
$chk = mysql_free_result($result);
mysql_close;
?>
|
Page>> |
$re = ceil($num/20);
$rt = 0;
if ($m == 0) {
$g = 1;
}
$pa = 1;
//$re = 15;
for ($i=1;$i<=$re;$i++) {
if ($i != $g) {
echo ' ';
echo $i;
echo ' ';
} else {
echo $i;
$pa = $pa + 20;
$rt = $rt + 20;
echo ' ';
}
}
?>
|
|
|
|
|
|
|
|
|