[PHP] Re: time stamp screwing up

2003-01-06 Thread Scott Fletcher
Instead of the php function, 'time()'. Try 'date()'. Somethine like this --clip-- ? //Long way around date(Y).-.date(m).-.date(d); //Shortcut date(Y-m-d); ? --clip-- You can customize the way you want the time format to be displayed. You can find it at

[PHP] Re: time stamp

2002-08-28 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... 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 Use an ORDER BY on the timestamp field in your select statement,

[PHP] RE: time stamp

2002-08-28 Thread Lopez David E-r9374c
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

[PHP] RE: time stamp

2002-08-28 Thread Steve Buehler
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