file check in select statement

[raduenea]

I have a table in mysql where i have save the name of some pictures.

exemple:

 

Select picture from table;

This will show all the pictures from that table.

 

The problem is that I have file names in mysql table that physically don't exist on disk. So, on select sometimes will show blank variables.

 

I want to insert a file check in the select statement .

I know that is possible in php but I want to make a select only with that files that physically exists.

How can I do that?

 

Thanks

 

 

 

[requinix]

Use file_exists when building the list. Or track in the table whether the file should or should not exist (and if they should always then there's something wrong).