Hi there i wonder if any1 can help me with a real silly problem.
I am tryin to insert an image into a mysql cell which is type varchar(500)
Basically this is what i am trying to insert :
<img alt=\'$reason\' src=../images/purple/smallcup_gold.gif width=16 height=13>
as you can see this is standard html for inserting an image, the alt of the image being the awkuad part.
i am trying to keep the original data and add another image next to it.
so i tried this statement :
$sql = \"UPDATE ut2003_clans SET cups=\'$cup1 <img alt=\'\'$reason\'\' src=../images/purple/smallcup_gold.gif width=16 height=13>\' WHERE clan_tag=\'$clan\'\";
mysql_query($sql);
here are what the variables =
cup1 = whats previously in the cell
alt = hello this is a test
i have been playin for this for a few hours now and its racking my brain, the main problem being the alt tag on the image.
It simply will display only the 1st word in the variable for example if
$reason = hello this is a test
it will only display hello.
I tried some error checkin and found that if remove the $reason variable and replace it with \' \'hello this is a test\' \'
it works fine
but then if i try double quotes around the variable $reason, it wont even insert anything??
I hope some1 can understand this and point me in the right direction
thanking you
Phil