Thank you David Lopez and David Robley. That was what I was looking for. Here is how I used it.
$date=getlastupdatetime(array("team_id" => $team_id, "season" => $season, "div_id" => $div_id)); echo "$date"; function getlastupdatetime($a){ extract($a); $result=mysql_query ("SELECT MAX(UNIX_TIMESTAMP(updated)) as epoch_time FROM games WHERE (hteam='$team_id' OR vteam='$team_id') AND sea_id = '$season' AND div_id = '$div_id'"); $date = mysql_result ($result, 0, 0); if(!$date){ return; }else{ return date("l dS of F Y h:i:s A O",$date); } } Which gives me the following line: Wednesday 28th of August 2002 06:00:06 PM -0500 I was doing the following which was a bit more code and I wanted to use a little less code. Plus it should make the search and processing quicker. $date=getlastupdatetime(array("team_id" => $team_id, "season" => $season, "div_id" => $div_id)); echo "$date"; function getlastupdatetime($a){ extract($a); $result=mysql_query("SELECT updated FROM games WHERE (hteam='$team_id' OR vteam='$team_id') AND sea_id = '$season' AND div_id = '$div_id'"); $b=0; while(($row=mysql_fetch_object($result))){ if($row->updated > $b){ $b=$row->updated; } } $date=$b; $year=substr($date,0,4); $month=substr($date,4,2); $day=substr($date,6,2); $hour=substr($date,8,2); $min=substr($date,10,2); if($hour >= 12){$ap = "pm";}else{$ap = "am";} if($hour > 12){$hour = $hour-12;} if(!$month){ return "nothing"; }else{ return "$month-$day-$year $hour:$min $ap<br>"; } */ } Thank Again Steve At 08:28 AM 8/28/2002 -0700, you wrote: >Steve > >Try: SELECT MAX(field_timestamp) from table1; > >David > > > -----Original Message----- > > From: Steve Buehler [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, August 27, 2002 5:21 PM > > To: mysql; PHP > > Subject: time stamp > > > > > > I am using PHP with MySQL and have a timestamp field in my db > > table. What > > would be the easiest way to get the newest timestamp out of the db? > > > > Thanks in Advance > > Steve > > > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > ow3 > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > >-- >This message has been scanned for viruses and >dangerous content by MailScanner, and is >believed to be clean. >ow3 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php