Mobiele telefoons
Merken
$brands = $db->fetchAll('SELECT naam, COUNT(*) AS aantal, SUM(sales) AS verkopen FROM `Merk` ' .
'INNER JOIN `Toestel` USING (merk_nr) ' .
'INNER JOIN `Toestel_eigenschap` USING (toestel_nr) ' .
'WHERE Merk.omgeving_nr IN (1, 2) AND Toestel.omgeving_nr IN (1, 2) AND Toestel.categorie_nr = 1 ' .
'AND Toestel.has_sublinks > 0 AND Toestel.has_retlinks > 0 AND Toestel_eigenschap.eigenschap_nr = 37 ' .
'GROUP BY merk_nr ORDER BY verkopen DESC');
$countBrands = count($brands);
$breakPoint = ceil($countBrands / 3);
for ($i = 0; $i < $countBrands; $i++) {
// New column
if ($i > 0 && $i % $breakPoint === 0) {
?>
Top 5 populair
$rows = $db->fetchAll('SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) ' .
'WHERE has_sublinks > 0 AND has_retlinks > 0 ' .
'ORDER BY sales DESC LIMIT 5');
foreach ($rows as $row) {
?>
}
// Clear results
unset($rows);
?>
Top 5 nieuw
$rows = $db->fetchAll('SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) ' .
'WHERE has_sublinks > 0 AND has_retlinks > 0 ' .
'ORDER BY datum_verkrijgbaar DESC LIMIT 5');
foreach ($rows as $row) {
?>
}
// Clear results
unset($rows);
?>