Linking to graphics

azurian

Hi.

I have a database driven website and I want to bae able to store links to images within the database. i am using the usual <img src> tag.

When I call the databse to show the image... it's not there even though it is pointing to the correct file.

Any help woud be much appreciated.

Chizzad

Hey,maybe you could show us some of your code and we could work through the problem with you.

-Chad

azurian

Ok fair enough. I guess I haven't given you much to go on.

I want to display a photo of a person alongside some text about them.

I have stored the text in a SQL field called PenPicture. As part of that text, I have included the tags <align=left><img src=photo.jpg height=220 width=250>.

So, the contents of the field looks something like this.....

<align=left><img src=photo.jpg height=220 width=250>. This person is new to PHP. please help!.

When I call the database from the php script, everything works fine except that there is a placeholder for the graphic, and no image. The text displays fine.

Chizzad

what type of placeholder? The first question I can think of ism is the image (photo.jpg) in the same file as the .php file is? If it is you may have to use tha absolute root to the image file. THat would be something along the lines of www/root/images/photo.jpg Depending on how your server is set up. I personally wouldn't go that route although it is the correct way to do it. I would use

src="http://www.mydomain.com/images/photo.jpg"

or whatever the URL to photo may be.

Hope this helps some! 🙂

-Chad

Pig

Your format is a bit off. You want to store JUST the url in the sql field. Then when you want to display it, you must put:
echo("<img src=\"$row[PenPicture\" align=left>");

One of the biggest advantages of using a database is to seperate format from data. By including the <img> tag information in the field, you are contradicting this.

Also, if you can show us the outputted HMTL, it will help determine the problem.

azurian

Thanks everyone. Done and dusted!