I would recommend the cronjob too but if you want to just keep the script running, do
a while-loop around your code, i.e.
while(1) {
... your code
sleep(120); // sleep 120 seconds
}
---
the require should be outside of the loop IMHO ;).
thomas
On Sat, 5 Jun 2004 21:46:20 +0600 [EMAIL PROTECTED] (Curlybraces Technologies \ Ltd)
wrote:
> hi friends ,
>
> when running this php script we can make a log file with relavent to the mysql data
> base. but i need to execute this script after every 2 min time. that is mean there
> must be a 2 min sleep time . can somebody help me do this function plz .........?
>
>
>
> <?php
>
> require ('connectMySql.php');
>
> $select= " select ServiceNo, ServiceName, Status, DateTime from ServiceStatus ";
>
> $add_member = $db_object->query($select);
>
>
>
> $result=mysql_query($select);
> while($row=mysql_fetch_array ($result))
> {
> $output1 =$row['ServiceNo'];
> $output2 =$row['ServiceName'];
> $output3 =$row['Status'];
> $output4 =$row['DateTime'];
>
>
> $your_data .= " $output1.\t $output2 -> $output3 -> $output4 \n";
>
> $output = "$your_data \n";
>
>
> }
>
> // Open the file and erase the contents if any
> $fp = fopen("vas_status.log", "a");
>
>
> // Write the data to the file
> fwrite($fp, $output);
>
>
> // Close the file
> fclose($fp);
>
>
> if (DB::isError($add_member)) {
> die($add_member->getMessage());
> }
>
> $db_object->disconnect();
>
> ?>
>
>
> thanx in advance
>
> curlys
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
