well, from what you show here you are trying to use a MYSQL timestamp format
string in a UNIX Timestamp String.
what you need to do is add add this to your select statement.
SELECT UNIX_TIMESTAMP(<replace with column name>) From Table;
you want to convert the MYSQL timestamp into a UNIX timestamp.
then just through that into the date function and if should work.
Jim Lucas
www.bend.com
----- Original Message -----
From: "Frank Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 9:21 AM
Subject: [PHP] Formatting a MYSQL time
> Hello,
>
> Since I'm the only one who uses php at work I run into a
> little problem and was hoping maybe someone could help me. I've set up a
> Mysql database that has an event time. I've set the field in the table
> as: eventtime time DEFAULT 00:00:00.
> When I go to print the eventtime I'm pulling it out of Mysql with the
> following code snippet
>
> while ($row = mysql_fetch_array($result)) {
> $dateofevent = $row["dateofevent"];
> $sponsor = $row["sponsor"];
> $location = $row["location"];
> $eventtime = $row["eventtime"];
> $contact = $row["contact"];
>
> All of this works. I connect to Mysql and pull out the data.
>
> Then I'm formatting $eventtime with $etime = date("g:i a", $eventtime);
>
> The problem is that when I print $etime in an html table all I get is 6:00
> pm for all the events. When I print $eventtime I get the correct time
that
> is stored in Mysql. My question is am I doing this correctly or do I need
> to use another function to format a mysql time.
>
> Thanks in advance.
>
> Frank Miller
> Computer Specialist and Webmaster
> Technology and Distance Education
> Texas A&M University-Texarkana
> 2600 North Robison Rd
> Texarkana, Texas 75501
>
> Phone: 903-223-3156
> Fax: 903-223-3139
> Office: 165
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
