Quote:
Originally Posted by GigoloShawn
A blob field is usually considered to be binary data.
You're gonna want to escape that.
If you want to display text, you should use TEXT or TINYTEXT and not BLOB for storage.
|
unfortunately this script was coded by someone else, i'm trying to clean up all the problem areas that I find. I need to decode the binary
unserialize(base64_decode($result)) didnt work... any suggestions? Once I figure out how to decode and retrieve the data I've setup 4 separate fields in which I plan to populate all current user data too and eliminate the BLOB field
this code below just shows me the encoded info, i need to decode it
$res = mysql_query("SELECT m_addtn FROM s_viz WHERE m_id = '39'");
$result = mysql_fetch_array($res);
echo var_dump($result);