[sde]

I want to make a new page which shows news, .. however I would like to format the time from my queries based on the offset the users put in their profile.

take this code for example:

PHP Code:

<?
$bbuserinfo[tzoffset]=-7;
$result = mysql_query("select title,body,unix_timestamp(time) as time from news order by time desc");
?>

how do i incorporate the tzoffset into my query to reflect the local time for the user viewing the news?

my time field is stored as a datetime type, .. i can change it to integer14 and store the unix timestamp if that is necessary.

thanks