Re: Formatting a MYSQL time

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" <frank.miller@tamut.edu> To: <php-general@lists.php.net> 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 > >