I have a database with 2 tables.
1 stores html code in a blob that might include text images calls etc.
the other table stores either text or an image call "<img src="images/ads/applehunts.jpg">
in a varchar field.
The blob works fine.
If I store text in the varchar field it is fine but if I store
<img src="images/ads/applehunts.jpg"> in the varchar field I get nothing with this code
Code: Select all
echo $rowї"Info"];Code: Select all
$mystring = htmlspecialchars($rowї"Info"]);
echo $mystring;<img src="images/ads/applehunts.jpg">
but no image.
Do I have to use a blob to store html code?
or am I doing something wrong?
Can I change the field type without loosing data?
Thanks
John