Gather All Information

treeleaf20

I have a column in the db called about, it allows a user to insert something about them, the type is blob so the person can write a lot with differnet spaces. My problem is that when I try and populate a text field with the data to allow them to update it only takes the first word before a space. How can I get it to select everything in that column to display it?

Thanks.

devinemke

why are you using BLOB? BLOB fields are used for storing large amounts of binary data. you shoud be using a TEXT field.

treeleaf20

Ok I'll make that change, what is the limit of TEXT? Any idea why the whole thing isn't displaying and is only gathering the information up to the space??

Weedpacket

Without actual detail it's hard to say. Best guess is that you're using a form field to display it and you didn't quote the value= attribute's value.

As for the limit in size on a TEXT field - that depends on your DBMS. For MySQL it's about 64kB; for PostgreSQL it's unlimited.

treeleaf20

This is the query and followed by the code I use:

$querypopulate = "SELECT interests, nickname, about, favsport, favplayer, greatest, homepage, teamhomepage, location, yahoo, msn, icq, aim, favmovie from profile WHERE user_name = '$_SESSION[Username]'";

$populate = mysql_query($querypopulate) or die("Select Failed!");
$populate = mysql_fetch_array($populate);

echo "<td class=\"text\"><p><input name=\"about\" type=\"text\" size=\"70\" value=$populate[2]></p></td>";

Also does it matter if I use blob? Does it have any effect on DB performance?

Thanks for the help.

Weedpacket

echo " Best guess is that you're using a form field to display it and you didn't quote the value= attribute's value.";