Originally Posted by fondy98
I need to get the timestamp for the last reply to a ticket from the parent id number. In this example would be the parent id number 16.
This gives you what you want, right ?
SELECT MAX(`timestamp`) FROM replies WHERE type = 'ticket' and parent = "16"