require("internal/global.php3");
$numrows=12; // set how many topics per page
$tmplink = "";
$db = mysql_connect($hostname,$username,$password) or die ("Could not connect");
mysql_select_db($databasename,$db);
$tempstrsize = "";
$tempstrsize1 = "";
if ($L != "s")
{
$tempstr = "SELECT * FROM velg order by type";
}
else
{
$tmplink = "&L=s";
$tmpselect = "SELECT distinct velg.type, velg.gbr FROM velg,velgsize";
$tempstr = " WHERE velg.type=velgsize.type AND ";
$tmplink = "&L=s&size=" . $size . "&hole=" .$hole . "&et=" . $et . "&pcd1=" . $pcd1 . "&pcd2=" .$pcd2;
if ($size != "ALL")
{
$tempstr .= "(velgsize.size='" . $size . "') AND ";
$tempstrsize = " holes.size='" . $size . "' AND";
$tempstrsize1 = " et.size='" . $size . "' AND";
}
if ($hole != "ALL")
{
$tmpselect .= ",holes";
$tempstr .= "(velgsize.type=holes.type And" . $tempstrsize . " holes.hole=" . $hole . ") AND ";
}
if ($et != "ALL")
{
$tmpselect .= ",et";
$tempstr .= "(velgsize.type=et.type And" . $tempstrsize1 . " et.etid=" . $et . ") AND ";
}
$tempstr .= "((velgsize.pcd_range1 >= $pcd1) AND (velgsize.pcd_range2 <= $pcd2)) order by velg.type";
$tmppage="search";
$tmpselect = $tmpselect . $tempstr;
$tempstr = $tmpselect;
}
$result = mysql_query($tempstr,$db);
$th = array();
$type = array();
for ($i=1; $i <= $numrows; $i++)
{
$th[$i] = "";
$type[$i] = "";
$new[$i] = "";
}
$counter = 0;
while ($row = mysql_fetch_array($result)) {
$counter += 1;
}
mysql_close($db);
$numpage = $counter / $numrows;
$numpage = intval($numpage);
if (($counter % $numrows) != 0) {
$numpage += 1;
}
$rowstart = ($Page - 1) * $numrows + 1;
if ($Page == $numpage) {
if (($counter % $numrows) != 0) {
$numrows = $counter % $numrows;
}
}
$db = mysql_connect($hostname,$username,$password) or die ("Could not connect");
mysql_select_db($databasename,$db);
$tempstrsize = "";
$tempstrsize1 = "";
if ($L != "s")
{
$tempstr = "SELECT * FROM velg order by type";
}
else
{
$tmpselect = "SELECT distinct velg.type, velg.gbrkecil FROM velg,velgsize";
$tempstr = " WHERE velg.type=velgsize.type AND ";
if ($size != "ALL")
{
$tempstr .= "(velgsize.size='" . $size . "') AND ";
$tempstrsize = " holes.size='" . $size . "' AND";
$tempstrsize1 = " et.size='" . $size . "' AND";
}
if ($hole != "ALL")
{
$tmpselect .= ",holes";
$tempstr .= "(velgsize.type=holes.type And" . $tempstrsize . " holes.hole=" . $hole . ") AND ";
}
if ($et != "ALL")
{
$tmpselect .= ",et";
$tempstr .= "(velgsize.type=et.type And" . $tempstrsize1 . " et.etid=" . $et . ") AND ";
}
$tempstr .= "((velgsize.pcd_range1 >= $pcd1) AND (velgsize.pcd_range2 <= $pcd2)) order by velgsize.type";
$tmpselect = $tmpselect . $tempstr;
$tempstr = $tmpselect;
}
$result = mysql_query($tempstr,$db);
$Pos=1;
while ( ($Pos < $rowstart) && ($row = mysql_fetch_array($result)) ) {
$Pos += 1;
}
$mycounter = 1;
if ($counter >= 1) {
for ($i = $rowstart; $i <= $rowstart+$numrows-1; $i++) {
$row = mysql_fetch_array($result);
$type[$mycounter] = $row["type"];
$th[$mycounter] = "
";
if ($row["new"] == 1)
$new[$mycounter] = "NEW";
$mycounter++;
}
}
// else
// { echo "There is no item. ";
// }
?>
PRODUCT CATALOG |
|
|
Meshindo Alloy Wheel Factory & Office Margomulyo Indah I Kav. 8-9 Surabaya 60186 - Indonesia Tel. (62) - (31) - 7491754 -56/60, 7482266 Fax. (62) - (31) - 7482277, 7491759 Email : info@meshindo.co.id |
|
©Copyright Meshindo Corp, 2001 |