Jump to content

White space missing in Text Database Field


Urbley

Recommended Posts

Ok I have tutorials stored in my database.  But when I retrieve the information there are white spaces between some words missing.  The field is of format Text.  The information is being added to the database via PHP.  I used phpMyAdmin to go in and look at the info contained within the database and yes the spaces are missing there also.  Any ideas anyone?  All entries in this Text field called content are behaving the same.

 

Ok so just to update as I am still looking in to this right now,  It appears that because I used a textarea to input the code the line breaks have been removed from the textarea input and no spaces have been included.  EEK!!!

 

HELP!

<textarea name="contents" rows="40" cols="30"></textarea>

 

for the input field in the form.

 

$content = $HTTP_POST_VARS['contents'];
//Other vars of course!

$db = mysql_connect("**********", "********", "*********");
mysql_select_db("*******",$db);

$dbQuery="INSERT INTO table VALUES ('$numPosts', '$title', '$dateAdded', '$tuning', '$vidName', '$imagename', '$content')";
$result = mysql_query($dbQuery,$db);

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.