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
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,
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
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
4 matches
Mail list logo