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
----- Original Message -----
From: "Frank Miller" <[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
> 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

Reply via email to