Thread: pulling a timestamp from table
View Single Post
Old 02-27-2013, 07:49 AM   PM User | #6
BubikolRamios
Senior Coder

 
Join Date: Dec 2005
Location: Slovenia
Posts: 1,876
Thanks: 114
Thanked 76 Times in 76 Posts
BubikolRamios is on a distinguished road
Quote:
Originally Posted by fondy98 View Post

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 ?
Code:
SELECT MAX(`timestamp`) FROM replies WHERE type = 'ticket' and parent = "16"
__________________
Found a flower or bug and don't know what it is ?
agrozoo.net galery
if you don't spot search button at once, there is search form:
agrozoo.net galery search
BubikolRamios is offline   Reply With Quote
Users who have thanked BubikolRamios for this post:
fondy98 (02-27-2013)