err wait, .. that does help me figure out how to display the user's current time .. and query against that, .. but when i display my news, it will always display the same news articles. there will be no 'where' clause.
when i loop through the news, i need to display the time as the user's current time.
.. heh and as i think about it, would i do something like this?
PHP Code:
<?
$result = mysql_query("select title,body,unix_timestamp(time) as time from news order by time desc limit 10");
while($row = mysql_fetch_array($result)){
// does this next line convert the news article time to the user's timezone?
$timestamp = vbmktime(0, 0, 0, vbdate('m', $row[time], false, false), vbdate('d', $row[time], false, false), vbdate('Y', $row[time], false, false));
}
?>
thanks
05-24-2004, 05:15 AM
Threaded Mode