if empty record..what's wrong?

[vinny199]

Hi,

I have an picture field in my database table "artwork" called [largepic]. I have on my page placed an image file wich gets the picture dynamically from the table and all is well.

Only thing is that if there is no picture path/file.jpeg in my [largepic] row, then on the page an little picture placeholder appears.. you know the one, when ie cant find a pic, it places this little gif with a cross.

In order to avoid that, I want to say:

if row [largepic] is empty (no path/file.jpeg inserted) then do not show picture. (or as I tried to say it, only display picture is [largepic] is different from "nothing"

I did the following below, but I get errors, and I know it is not quite right, but maybe you can help me further?

<?php
if ($row_rsartwork['largepic'] <> "")
echo "<img src="../upload/artwork/large/$row_rsartwork['largepic']; ">" ?>

Thanks a lot,

vinny

[weekender]

why not just have a default picture that appears if there is no url stored?

if ($row_rsartwork['largepic'] != ""){
echo "<img src=\"..upload/artwork/large/{$row_rsartwork['largepic']}\">";
} else {
echo "<img src=\"..upload/artwork/large/noimage.jpg\">";
}

i also escaped the double quote characters... you should watch out for that

adam