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