$query = "
SELECT * FROM artikler
WHERE id > 0
AND public='1'
ORDER BY id DESC
";
$display['recent'] = $db->GetAll($query . "LIMIT 0,3");
mysql_num_rows($query)
SELECT art.*, count(*) AS kommentarantall
FROM artikler AS art, kommentarer AS kom
WHERE art.id > 0
AND art.public='1'
AND art.id = kom.artikkelid
GROUP BY art.id
ORDER BY id DESC
SELECT a.*, COUNT(k.id) AS kommentarantall FROM artikler a LEFT JOIN kommentarer k ON k.artikkelid = a.id WHERE a.public = '1' GROUP BY a.id ORDER BY a.dato DESC
Registrerte brukere: Google [Bot]