Problems with Hour, minute, second query

From: Date: Wed, 13 Sep 2000 13:12:22 +0000
Subject: Problems with Hour, minute, second query
Groups: php.general 
Request: Send a blank email to php-general+get-16526@lists.php.net to get a copy of this message
HI, I want to select the HR, min , second from a time field in Mysql.It works when i do with Mysql directly. But the following code returns the same value for hour, minute and seconds. No clues. Please help.
          $query13="select hour(setuptime) ,minute(setuptime),      second(setuptime) from prodntime where prod_id='1'";
             if(!mysql_query($query13,$link)) print'Query13 failed';
           $setup=mysql_query($query13,$link);
           $numm=mysql_num_rows($setup);
           echo" $numm Rows selected<br>";
           $setuphr=mysql_result($setup,"hour(setuptime)");
           $setupmin=mysql_result($setup,"minute(setuptime)");
           $setupsec=mysql_result($setup,"second(setuptime)");
           echo" setup time is $setuphr : $setupmin : $setupsec<br>";
"sadhasivammanohar@hotmail.com" Thanks, manohar _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

« previous php.general (#16526) next »