View Single Post
Old 02-27-2013, 07:00 PM   PM User | #18
fondy98
New Coder

 
Join Date: Feb 2013
Posts: 15
Thanks: 9
Thanked 0 Times in 0 Posts
fondy98 is an unknown quantity at this point
This is some of the code:

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

Last edited by fondy98; 02-27-2013 at 07:06 PM.. Reason: I still cannot get it to budge
fondy98 is offline   Reply With Quote