$catno1="1";
$catno2="3";
$cat="Pick-Up";
include("userpass.php3");
mysql_connect ($host, $users, $password) or die ("File not found");
mysql_select_db ($database);
$result = mysql_db_query ($database, "select * from brand where (catno='$catno1') or (catno='$catno2') order by orderx");
while ($row = mysql_fetch_array ($result)) {
$brand = $row['brand'];
?>
echo $row['brand'];?>
$resultx = mysql_db_query ($database, "select * from model where (brand = '$brand')order by orderx");
while ($rowx = mysql_fetch_array ($resultx)) {
$model=$rowx['model'];
$results = mysql_db_query ($database, "select * from part where (brand = '$brand') and (cat = '$cat') and (model = '$model') group by year1 order by year1");
while ($rows = mysql_fetch_array ($results)) {
?>
$catno1="2";
$catno2="3";
$cat="Truck";
include("userpass.php3");
mysql_connect ($host, $users, $password) or die ("File not found");
mysql_select_db ($database);
$result = mysql_db_query ($database, "select * from brand where (catno='$catno1') or (catno='$catno2') order by orderx");
while ($row = mysql_fetch_array ($result)) {
$brand = $row['brand'];
?>
echo $row['brand'];?>
$resultx = mysql_db_query ($database, "select * from model where (brand = '$brand')order by orderx");
while ($rowx = mysql_fetch_array ($resultx)) {
$model=$rowx['model'];
$results = mysql_db_query ($database, "select * from part where (brand = '$brand') and (cat = '$cat') and (model = '$model') group by year1 order by year1");
while ($rows = mysql_fetch_array ($results)) {
?>