[SOLVED] folder list and compare

[didgydont]

hi all

i have managed to list all jpg files in a folder but want it to check a sql data base and see if file is used i have came close

this code below marks 1 file as used

<?php
include("connect.php");
$result = mysql_query("SELECT * FROM stock");
while($row = mysql_fetch_array($result))

  {
  $image = $row['image'];
     }
//############ folder list###################3
echo "Pictures On Server..<br>";
$folderc = "Images";
$dir=dir("./$folderc/.");
while($filename=$dir->read()) {if(eregi("^[_a-z0-9-]+.jpg$", $filename)){
  if ($filename==$image){echo "$filename in use</br>";}
  else {echo "$filename </br>";}
  }

}  
$dir->close();
?>

but this code below list all the right files but repeats it self as many times as pictures

<?php
include("connect.php");
$result = mysql_query("SELECT * FROM stock");
while($row = mysql_fetch_array($result))

  {
  $image = $row['image'];
//############ folder list###################3
echo "Pictures On Server..<br>";
$folderc = "Images";
$dir=dir("./$folderc/.");
while($filename=$dir->read()) {if(eregi("^[_a-z0-9-]+.jpg$", $filename)){
  if ($filename==$image){echo "$filename in use</br>";}
  else {echo "$filename </br>";}
  }

} } 
$dir->close();
?>

thank you for your time

[sader]

Not sure but how about this

 

<?php

//############ folder list###################3
echo "Pictures On Server..<br>";
$folderc = "Images";
$dir=dir("./$folderc/.");
while($filename=$dir->read()) 
{
 	if(eregi("^[_a-z0-9-]+.jpg$", $filename))
	{
  		//now try find this filename in database
  		$result = mysql_query("SELECT * FROM stock WHERE image='$filename' LIMIT 1");
  			
  		//was there any results returned by query
  		if(mysql_num_rows(result)>0)echo "Image in use<br />"; else echo "Image unused<br />";
  		}

} 
             $dir->close();
?>

[didgydont]

this is what i did

<?php
include("connect.php");
///////////////////////////////////
$result = mysql_query("SELECT * FROM stock");
while($row = mysql_fetch_array($result))

  {
  $image = $row['image'];
     }
//############ folder list###################3
echo "Pictures On Server..<br>";
$folderc = "Images";
$dir=dir("./$folderc/.");
while($filename=$dir->read()) {if(eregi("^[_a-z0-9-]+.jpg$", $filename)){
  $sql3 = "select * from stock where image='$filename'";
$result3 = mysql_query($sql3);
if (mysql_num_rows($result3)== 1) {echo "$filename in use</br>";}
  else {echo "$filename </br>";}
  }

}  
$dir->close();
?>

[didgydont]

Not sure but how about this

 

<?php

//############ folder list###################3
echo "Pictures On Server..<br>";
$folderc = "Images";
$dir=dir("./$folderc/.");
while($filename=$dir->read()) 
{
 	if(eregi("^[_a-z0-9-]+.jpg$", $filename))
	{
  			//now try find this filename in database
  			$result = mysql_query("SELECT * FROM stock WHERE image='$filename' LIMIT 1");
  			
  			//was there any results returned by query
  			if(mysql_num_rows(result)>0)echo "Image in use<br />"; else echo "Image unused<br />";
  		}

} 

?>

thank your for your help i will try that too just for learing