[RESOLVED] help with timed delayed loop

[thenerse]

Hi Everyone

I have a query which checks to see if a process is running.

I want to create a loop so that if the query shows the process is running, sleep for 10 minutes and check again and not move on until the query returns the result "complete"

i know this is wrong, but this is sort of the delay I want to create, but have it loop until the result is 0:

$c= mysql_query("SELECT * FROM track WHERE status = 'active' GROUP by trackid ORDER BY trackid");
		$d= mysql_num_rows($c);
       	if($d> 0) sleep(600);

Can someone help or point me in the right direction as I have no looping experience..

many thanks

[NogDog]

Probably the most basic way:

while(true)
{
   $c= mysql_query("SELECT * FROM track WHERE status = 'active' GROUP by trackid ORDER BY trackid");
   $d= mysql_num_rows($c);
   if($d > 0)
   {
      sleep(600);
   }
   else
   {
      break;
   }
}

[thenerse]

this works perfectly.. I was able to incorporate the loop elsewhere in my code to reduce number of queries and such so this was a big help..