javascript and php?

richard.york · September 16th, 2004, 08:00 AM

I'd convert the stamps to Unix timestamps and then use PHP's date() function. I think you can retrieve the timestamp from the DB in unix time by applying a function there. You'd have to RTM though.

Otherwise there's strtotime.
http://www.php.net/strtotime

That (tries to) create a UNIX timestamp from any date string. Then you can format the date however you like. And then naturally you'd use,

mktime() > $data['timeend'];

so that you're comparing two Unix timestamps.

I'd try to extract the timestamp from the database already in unix timestamp form, since that'd be the most efficient approach.

HTH!

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

sami · September 23rd, 2004, 01:40 PM

Thanks Rich,
You were right about needing to convert the timestamps as now I can calculate the time differences properly: here's how I have done it (for anyone else looking for the solution):

Code:

Auction Started: 
<?php
$result2=mysql_query("SELECT UNIX_TIMESTAMP(timestarted) AS FORMATTED_STARTTIME FROM table where item=$_GET[item]"); 
$FORMATTED_STARTTIME=mysql_result($result2,0,"FORMATTED_STARTTIME"); 
$date1=date("l-j-F-Y H:i:sa",$FORMATTED_STARTTIME); 
echo "$date1"; ?>

Auction Ends: 
<?php 

$result3=mysql_query("SELECT UNIX_TIMESTAMP(timeend) AS FORMATTED_ENDTIME FROM table where item=$_GET[item]"); 
$FORMATTED_ENDTIME=mysql_result($result3,0,"FORMATTED_ENDTIME"); 
$date2=date("l-j-F-Y H:i:sa",$FORMATTED_ENDTIME); 
echo "$date2"; ?>

and then using:
$diff=$FORMATTED_ENDTIME-mktime();
to calculate the difference in seconds.

Thanks very much for your help
Sami