Multiple unlinks

[jonki]

Hi - I want to simply delete old entires out of my database and I want to also delete the associated image file with each entry.

Can anyone give me a hint?

if date < $todaysdate - 1 month then ....... remove rows and unlink the asociated file......

It should be very simple.

(By the way I am not asking anyone to write the code out for me, I just want the concept .. eg do I need to put it in a loop or is there an easier way?)

Thanks a lot.

[drawmack]

what you'll have to do is this

1) query the database for all entries older then epoch
2) retrieve the entries one at a time
3) use the retrieved information to unlink the file and build an array of ids to delete
4) delete the entries whose ids are in the array created in step three
5) marvel at the wonders of database driven web sites
6) donate $10,000 usd to the underpaid programmers fund, which incidently uses my paypal account.

[jonki]

Is there a possibility of doing it like this?

$deletedate = mktime(0, 0, 0, date("m")-3  , date("d") , date("Y"));

 $query = "SELECT * FROM db WHERE date < '$deletedate' "; 

 $result = mysql_query($query); 

if (mysql_num_rows($result) != 0)

// CAN I PUT A for_each STATEMENT HERE SOMEHOW?	

{

$data = mysql_fetch_array($result);  

$query = "DELETE FROM db WHERE ";
  // DONT KNOW WHAT TO PUT HERE 
    $result = mysql_query($query); 


print "<p><b> Your ad has been deleted</b></p>\n";

if ( $data[foto] != "ejemplo.gif")
	{
  	unlink("../../fotos_coches/" . $data[foto]); 

}

[jonki]

Thanks a lot for your help drawmack but can you explain what you mean exactly with "retrieve the entries one at a time "

??

Thanks

[drawmack]

$deletedate = mktime(0, 0, 0, date("m")-3  , date("d") , date("Y"));

 $query = "SELECT * FROM db WHERE date < '$deletedate' "; 

 $result = mysql_query($query); 

//appended second condition to stop errors from 
//displaying if the query failes 
if ($result !== FALSE && mysql_num_rows($result) != 0){
    while(($data = mysql_fetch_assoc($result)) !== FALSE) {
        $query = "DELETE FROM db WHERE id = " . $data['id'];
        mysql_query($query);
        if ( $data[foto] != "ejemplo.gif")
            unlink("../../fotos_coches/" . $data[foto]); 
    } //end while
} //end if

I think this will do what you want, but I havn't tested it so it's probably got some bugs.

[jonki]

BRilliant - Thanks for your help!!!

I will check it out first thing in the morning.