 |
$col = 0;
// get brands
$Query = "SELECT id, brand FROM product_brand ORDER BY border";
$result=mysql_query($Query,$Conn) or die('There is error on this website, please come back later!');
while ($row = mysql_fetch_row($result)){
if($col%5 == 4){
?>
}
?>
| |
|
$Query2 = "SELECT id, sub_brand FROM product_sub_brand WHERE brand='$row[0]' ORDER BY sub_brand";
$result2=mysql_query($Query2,$Conn) or die('There is error on this website, please come back later!');
$count = 0;
while($row2 = mysql_fetch_row($result2)){
$color = "#C9D9F2";
if($count%2 == 0){
$color = "#B7CDEA";
} else{
$color = "#C9D9F2";
}
$count++;
?>
| > echo $row2[1]; ?> |
}
?>
|
|
|
if($col%5 == 4){
?>
}
$col++;
}
?>
|
| |
|
|
|
|