Link a "default" image if original is no

[Anon]

Hi,

I have a MySQL database with a field called "code", it is the product code and
is equal to the image name.

I've already made a page that shows the right image for the selected product.

Unfortunally I have not all the images, so for some products there is no image displyed but a broken link.

What I want to do, is to find a solution in order to put a default image when the "original one is not available.

Have you some sample code to study in order to reach this result ?

Thank you very much

Fabio

[Anon]

Have you checked the manual page for Filesystem
Functions? There's a number of ways to do this,
but the simplest one (file_exists) will probably
do what you need.

[Anon]

Is the problem that you're not sure whether the actual file specified in the code column exists, or the code column can be empty, when no picture is selected??

For the first part, use the file_exists() like Kirk said.

For the second, you can actually set a column default when you create the table to point to a default image. That way you won't have to change your code at all. If nothing is set when inserting into the database, it'll put the default value in, which is your default picture...

Hopefully that's clear...let me know if not.

---JH