display wrong

brauchi

I am having some problems with a script i am writing. I built an interface that let me add and edit entries from a table. But there is a problem. One of the fields is holding a picture URL including the "IMG src= " tag. And when the script runs than the systems only shows <IMG SRC= and before the next field I will see the last characters >"

Is there a way to view the complete information?

it seems to me as the script doesn't want to see the " within the field information. how can i get around this?

Thank you in advance

andrea

diego25

Check out
http://www.php.net/manual/en/function.htmlspecialchars.php

Diego

barand

If I run the following, which places an image tag in a db field, then selects and echoes it, it works OK and I get the gif image displayed.

mysql_query("insert into tablea (description) values ('<img src=\"baa.gif\" border=\"0\" width=\"64\" height=\"64\" >')");
$res =  mysql_query("select description from tablea where id=18");
list($desc) = mysql_fetch_row($res);
echo $desc;

How is yours different?

Frederick

setup you page to have the

echo "<img src=".$row["fieldname"]." width=100>";

Recall the information about the url only.

If this is comming from a field in MySQL that is set as TEXT. Use the addslashes function to add double and single quotes.

$str = addslashes($image);

$sql = mysql_query("INSERT INTO tablename (image) VALUES ('$str') ",$db)
or die(mysql_error());

$sql = mysql_query("UPDATE tablename SET image='$str' WHERE id=$id",$db)
or die(mysql_error());

brauchi

Thank you. I change the settings so that I only have the /images/pic.gif in the table and this is working just fine.

andrea