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

Reply via email to