Formatting a MYSQL time
| From: | Frank Miller | Date: | Thu, 07 Feb 2002 17:21:13 +0000 |
| Subject: | Formatting a MYSQL time | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-83875@lists.php.net to get a copy of this message | ||
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 snippetwhile ($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-3139Office: 165