Problems with Hour, minute, second query
| From: | manohar sadhasivam | 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.