Storing image alt tags in database [RESOLVED]

[AdRock]

I have stored my images in the database by having their name such as [b]something.jpg[/b] in a name field and in the alt field I have the alt tag such as [b]this is a picture of something[/b]

When i come to display the picture I get the picture displayed ok but the alt tag has only the first word shown so in my example it would display [b]the[/b]

Any ideas what would cause this?

[code]echo "<p class='style2'><img src=/images/".$code['photo']." alt=".$code['alternate'].">".nl2br($code['content'])."</p>";[/code]

[majocmatt]

alt=".[color=red]addslahes([/color]$code['alternate'][color=red])[/color]."

[AdRock]

Doesn't work....still only displays the first word

[majocmatt]

It seems like your problem is apostraphes in your captions (alts), are you sure its printing just the first word? Or is it printing all the letters up until an apostraphe or slash?

[AdRock]

In my caption (alts) I have about 4 words whith no apostrophes and slashes or anything.

I checked in phpMyAdmin and I can see all the alts i'm trying to echo all have the same first word

I tested a different word on another image and the same thing happens.....only the first word

[AdRock]

I just echoed what was in the alternate field (alt tag) and what was echoed is what should be displayed in the image alt tag

[majocmatt]

Yea I've had that problem before displaying alt's, I'm just trying to think how I fixed it because I can't find the files.

did you try stripslashes too?

[MarioRossi]

Your problem lies not within the PHP but the html you are outputting. If you view the source of the page you will see what I mean.

what you are outputting is this

<img src=/images/yourimageurl.gif alt=Your alt text>

The spaces therfore are not associated with the alt attribute.

Try this

echo "<p class='style2'><img src='/images/".$code['photo']."' alt='".$code['alternate']."'>".nl2br($code['content'])."</p>";

I have added single quotes to contain your values for SRC and ALT

Hope that works for you.

[AdRock]

I did try using single quotes but obviously put it in the wrong place and it made the images disappear
Thanks MarioRossi, it works.......woohoo