HELP

timmaher · March 15th, 2004, 12:02 PM

Hi,

I'm successfully retrieving records from a mysql table. One of the fields in this table holds the url to an image eg :

"http://localhost/lists/images/img.gif"

The record is displaying a broken image link. The code im using to write the table looks like:

while ($row=mysql_fetch_array($mysql_result))
{
$id=$row["id"];
$image=$row["image_url"];
$var_1=$row["gift_type"];
$var_2=$row["desc"];
$var_3=$row["url"];
$var_4="<a href='$var_3'>Select</a>";

echo $image;
echo "<br>";

echo "<TR align=\"center\"><TD><img source=\"$image\"\"></></TD><TD>$var_1</TD><TD$var_2</TD><TD>$var_4</TD></TR>";
}
}

mysql_close($connection);

?>
</TABLE>

As i have said, the records are being displayed fine - Just no images!!!!!

If anyone can help I will be very grateful!!!

TIA

Tim

Tim

Snib · March 15th, 2004, 04:49 PM

This is really messed up...

echo "<TR align=\"center\"><TD><img source=\"$image\"\"></></TD><TD>$var_1</TD><TD$var_2</TD><TD>$var_4</TD></TR>";

This should be:

echo "<TR align=\"center\"><TD><img src=\"$image\"></TD><TD>$var_1</TD><TD>$var_2</TD><TD>$var_4</TD></TR>";

Noticed what I added in red and I took out the silly-looking </> and the extra \" (which was probably what was causing your problems)

Hope this helps,

----------
---Snib---
----------

timmaher · March 16th, 2004, 04:37 AM

Worked a treat!! Excellent!! Many thanks for your help Snib!!

Tim

nikolai · March 17th, 2004, 09:16 PM

Note for reference: </> is a valid SGML tag that's a shorthand for "Close the last opened tag", but it's NOT valid in HTML or XML. You need to explicitly name the tags you're closing in these markup languages.

Take care,

Nik
http://www.bigaction.org/

Capt D · January 26th, 2005, 01:10 AM

Hello
I know that I'm repling very late to this topic but, your doing exactly what I want to do.
Hi,
I'm successfully retrieving records from a mysql table. One of the fields in this table holds the url to an image eg :

"http://localhost/lists/images/img.gif

I created the table and I can sucessfully retrieve all the text records. I'll take the advice of the articles on image storage and not store my images in the databse itself. But, how do I store a hyperlink like you discussed table then use PHP to retrieve the image along with its corresponding text
Thank you
Capt D

Snib · January 26th, 2005, 03:09 PM

Depending on what you're doing, alter this code to your desire:

Code:

//right now, $image_url should be the URL to your image
//and $image_txt should be the corresponding text

echo "<img src='$image_url' alt='$image_txt'/>";

Is this something like what you need?

hth,

-Snib - http://www.snibworks.com
Where will you be in 100 years?