[PHP] Re: time stamp screwing up

2003-01-06 Thread Scott Fletcher
Instead of the php function, 'time()'. Try 'date()'. Somethine like this --clip-- --clip-- You can customize the way you want the time format to be displayed. You can find it at http://www.php.net/manual/en/function.date.php and you'll see the option for dates and times. "- -" <[EMAIL PROTEC

[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 getlastupda

[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 state

[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.