Re: Problems with Hour, minute, second query

HI, when i do like this, $query13 = "SELECT HOUR( setuptime ) AS Hour, " .

                   " MINUTE( setuptime ) AS Minute, " .
                   " SECOND( setuptime ) AS Second " .
                   "FROM prodntime " .
                   "WHERE prod_id = '1' ";

$setup = mysql_query( $query13 ); if( 0 == $setup ) die( 'Query13 Failed' ); while(list( $Hour, $Minute, $Second ) = mysql_fetch_row( $setup ))

       {   echo "setup time is $Hour:$Minute:$Second  <br>";}

       echo"setup time $Hour <br>";

the values of $Hour and others are  not    available  outside  the while. what should     i do   for   that.  Sorry if it is something silly.

thank you, mano

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; _________________________________________________________________________

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.