A conditional Select Statement? Huh?

[Fritz]

thanks to the wonderful help from this board last week I hacked up a conditional that will check for images (book covers)....

$bkimage= str_replace("-", "", $isbn);

if(file_exists("/pathtoimagefolder")){$covercheck = ""; }else {$covercheck = "<b>Missing</b>" ;}

What I'd like to do is a SELECT records statement that is based on the above conditional. to essentially return a list of all books where the cover image FILE doesn't exist.

possible?

syntax help?

[the_Igel]

I didn't really catch what variable stand for what 🙂. But here's a sketch of solution.

$tmp = '';
foreach (book)
if (there's no cover image)
{
$tmp .= $book_id.', '; //or $book_name or whatever
}
$tmp = '('. substr($tmp, 0, strlen($tmp - 2)).')';
// we need to cut last ', '.
query = "select * from table where bookId in $tmp";

Hope this helps.

[adamgeorge]

Hmm... I don't really see how your code works.... You don't provide an image...

file_exists("/pathtoimagefolder")){

maybe you forgot to append $bkimage to /pathtoimagefolder ?

anyway, I'll assume that's what you meant.

Your message is quite ambigous... when do you want the select? Are you supposed to select all books first, and then work out whether they have images or not? or do you all ready have a list of books, and you want to select * for which of those books don't have images?

since the_Igel provided the later, here's a solution to the former:

There is a PHP function that checks whether files exist or not. (file_exists) Why not just use a loop to loop through all the books, and check wheather their respective image files exist. If they don't add them to an array. (if that's what you meant by list)

Er, you can't actually use file_exists in your sql query though. I think that's what you wanted to do wasn't it? Just use a query like this:

select bookid, image from books;

and then a while loop or something to loop through each row returned and to check each image with file_exists. if doesn't exist then add the book id to an array... or similar.

hope that helps
-Adam 🙂