Deze code laat maar 4 linkpartners zien ipv de 7 die ik er nu in heb staan.
Hoe kan dit?
<?php
$queryKliks = "
SELECT
p.partner_id,
p.partner_naam,
p.partner_url,
COUNT(pk.datumtijd) AS aantal_kliks
FROM
klikspartners AS pk
INNER JOIN
partners AS p
ON
pk.partner_id = p.partner_id
WHERE
YEAR(pk.datumtijd ) = YEAR( CURDATE() )
GROUP BY p.partner_id
ORDER BY RAND()";
$resultKliks = mysql_query($queryKliks) or die (mysql_error());
while ($rowKliks = mysql_fetch_object($resultKliks))
{
echo '<a href="partneruit.php?partner_id='. $rowKliks->partner_id.'" title="'. $rowKliks->partner_naam.'" target="_blank">-'.$rowKliks->partner_naam.'</a> ['.$rowKliks->aantal_kliks.']<br>';
}
?>
1.414 views