Is This possible?

[SureFire]

I have a sound effects section on my site, its a real pain in the butt to add a sound to the search engine, but this would help if possible.

one field in my sound effects table is called PATH and in it is the sound effect link, for example: "a1/electronic/beep.wav"

Is it possible to read all the files in a folder and then only display the ones that don't show up in the database?

Say I only have a1/electronic/beep.wav input into my table but I have the sounds a1/electronic/beep2.wav and a1/animal/growl.wav in my directory....I would need a script that displays those last two.

That way I could write a function where you can just click the sound and type in the keywords and move on to the next.

Thanks in advance for all your help!

[Sxooter]

Sure, let's suppose you've got an array like so:

$files_in_dir=array("file1","file2","filex");
$query = "select * from table where filename not in ('";
$query.= implode("', '",$files_in_dir);
$query.= "')";

[SureFire]

Awesome!, I'll give that a shot!

Thank you