FOpen / FClose

[BulldogGC]

	$execute = mysql_query("SELECT url,id FROM passwords WHERE dateadded >= '".date('H:i:s',mktime(date('i')-15))."' ORDER BY id ASC");
		while($row = mysql_fetch_array($execute)) {
			if($site = fopen($row['url'],"r")) {
				$deleted = "no";
			}
			else {
				$deleted = "yes";
			}
				print($row['url']." ($deleted)<br>");		
		}

Any idea on how I can make that code work?
Right now it is only opening the first site and saying all the other are dead links ... when in actuality they aren't.

I've put an fclose statement EVERYWHERE and still no dice.

[tasistro]

if($site === fopen($row['url'],"r")) {

with three equals and don't forget to fclose it when you have succesfully opened it.

else {
$deleted = "yes";
fclose($site);
}

[BulldogGC]

Doesn't seem to work.
All it does with the following code now --

<?
include("../inc/config.php");
error_reporting(0);
	$execute = mysql_query("SELECT url,id FROM passwords WHERE dateadded >= '".date('H:i:s',mktime(date('i')-15))."' ORDER BY id ASC");
			fclose($site);
		while($row = mysql_fetch_array($execute)) {
			if($site === fopen($row['url'],"r")) {
				$deleted = "no";
			}
			else {
				$deleted = "yes";
				fclose($site);
			}
				print($row['url']." ($deleted)<br>");		
		}			
?>

Is delete EVERYTHING.

[tasistro]

Have you tried using file_exists?

http://www.php.net/manual/en/function.file-exists.php

[superwormy]

For starters, your fclose() statement is only closing files where the fopen() FAILED... so fix that and try it again.