View Single Post
  #4 (permalink)  
Old 08-08-05, 08:41 AM
ronlar ronlar is offline
Newbie Coder
 
Join Date: Jun 2005
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Smile

The matter is solved. By placing the code inside the while loop it works perfect.
Code:
<?php

include("settings.php");

$link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
$database = mysql_select_db(DB_NAME);
$sql = "SELECT * FROM temp WHERE DATE_ADD(time, INTERVAL 10 MINUTE) < NOW()";
$result = mysql_query("$sql");
while ($out = mysql_fetch_array($result)) { 
   $dirname = $out['directory'];
   $filename = $out['filename'];

   $file = "$dirname/$filename";

   if(file_exists($file))
   unlink($file);

   rmdir($dirname);
   
   $link = @mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
   $database = mysql_select_db(DB_NAME);
   $sql = "DELETE FROM temp WHERE directory = '$dirname'";
   mysql_query("$sql");
}

mysql_close($link);

?>

Last edited by ronlar; 08-08-05 at 08:52 AM.
Reply With Quote