|
$replied = $site->db->query("SELECT parent, MAX(`timestamp`) AS maxTimestamp FROM " . PREFIX . "replies WHERE type = 'ticket' GROUP BY parent");
if ($replied = $site->db->query($sQry))
{
while ($replies = $replied->fetch_assoc())
{
printf("Max timestamp for parent %s is %s" . PHP_EOL, $replies['parent'], $replies['maxTimestamp']);
}
$replied->free();
}
ANd I tried this too
|