Re: query question

Not sure if I wrote and thanked you or not, but this did the trick. THANK YOU THANK YOU THANK YOU!!!!!!!!!!! Steve At 08:41 PM 11/14/2002 +0100, Marek Kilimajer wrote:

This is checked: function getstart_end(){

       $result=mysql_query("SELECT * FROM aplayabletimes ORDER BY min");
       while(($row=mysql_fetch_object($result))){
               if(!$i){
                       echo $row->min . " - ";
                       $i=$row->min;
               } else {
                       list($houre,$minutee,$seconds)=explode(":",$i);
                       $minutee=$minutee+5;

if($minutee>=60){$minutee=$minutee-60;$houre=$houre+1;}

                       $tmp = implode(':',array(str_pad($houre,2,'0',STR_PAD_LEFT) ,str_pad($minutee,2,'0',STR_PAD_LEFT),'00'));

                       if($tmp != $row->min) {  // there is a gap
                           //echo $row->min ." != $tmp<br>";
                             echo $i ."<br>\n";  // print previous time as end
                             echo $row->min . " - ";  // print this time as new start
                       }
                       $i = $row->min; // keep this new time for next loop
               }
           //echo $i." - $tmp  --tmp<br>\n";
           //echo $row->min."<br>\n";
       }
       echo $i ."<br>\n";  // print last row

} Steve Buehler wrote:

Ok. That output was my fault. I had an error in one of my other functions. I needed to set $hours to "00" to start with in my populatetemptable() function. Now my output is: 00:05:00 - 00:05:00 00:05:00 - 00:10:00 00:10:00 - 00:15:00 00:10:00 - 00:20:00 00:15:00 - 00:25:00 00:15:00 - 00:30:00 Problem is that it isn't giving me just the start and end times. I will keep working on it. Thanks Steve At 12:48 PM 11/14/2002 -0600, you wrote:

Thanks for the help, but that is not actually producing the desired results either. This returns the following results: 00:00:05 - 00:00:05 00:00:05 - 5 00:00:05 - 10 00:00:05 - 15 00:00:10 - 20 00:00:10 - 25 00:00:10 - 30 00:00:10 - 35 00:00:15 - 40 00:00:15 - 45 00:00:15 - 50 00:00:15 - 55 00:00:20 - 60 00:00:20 - 65 I am not going to post all of them. :) Here is the code that is now in the getstart_end() function. I had to change the line that you had because the 5 minutes would give an error. I just took out the "minutes" part.

                        $tmp = $i+5 minutes; // add 5 minutes to $i, implement it yourself

function getstart_end(){

        $result=mysql_query("SELECT * FROM aplayabletimes ORDER BY min");
        while(($row=mysql_fetch_object($result))){
                if(!$i){
                        echo $row->min . " - ";
                        $i=$row->min;
                }else{
                        $tmp = $i+5; // add 5 minutes to $i, implement it yourself
                        if($tmp != $row->min) {  // there is a gap
                                echo $i ."<br>\n";  // print previous time as end
                                echo $row->min . " - ";  // print this time as new start
                        }
                $i = $tmp; // keep this new time for next loop
                }
        }
        echo $row->min ."<br>\n";  // print last row

} At 07:09 PM 11/14/2002 +0100, you wrote:

Untested, but should work Steve Buehler wrote:

function getstart_end(){

    $result=mysql_query("SELECT * FROM aplayabletimes ORDER BY min");
    while(($row=mysql_fetch_object($result))){
        if(!$i){
            echo $row->min . " - ";

               $i=$row->min;

        }else{

$tmp = $i + 5 minutes // add 5 minutes to $i, implement it yourself if($tmp != $row->min) { // there is a gap echo $i ."<br>\n"; // print previous time as end echo $row->min . " - "; // print this time as new start } $i = $tmp; // keep this new time for next loop

        }
    }

echo $row->min ."<br>\n"; // print last row

}

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3

-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3

-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3

-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ow3