Re: Problems with Hour, minute, second query

Addressed to: "manohar sadhasivam" <sadhasivammanohar@hotmail.com> php-general@lists.php.net ** Reply to note from "manohar sadhasivam" <sadhasivammanohar@hotmail.com> Wed, 13 Sep 2000 15:12:22 IST > > 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>"; I would do it like this... $query13 = "SELECT HOUR( setuptime ) AS Hour, " . " MINUTE( setuptime ) AS Minute, " . " SECOND( setuptime ) AS Second " . "FROM prodntime " . "WHERE prod_id = '1' "; Then to retrieve the data: $Result = mysql_query( $query13 ); if( 0 == $Result ) die( 'Query Failed' ); while( list( $Hour, $Minute, $Second ) = mysql_fetch_row( $Result )) { echo "setup time is $Hour:$Minute:$Second"; } Although, actually if all you want to do is display the time HH:MM:SS you should do it like this: SELECT DATE_FORMAT( setuptime, '%H:%M:%S' ) AS setuptime; See: http://www.mysql.com/documentation/mysql/commented/manual.php?section=Date_and_time_functions Rick Widmer Internet Marketing Specialists www.developersdesk.com