Urbley Posted May 13, 2007 Share Posted May 13, 2007 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! Quote Link to comment https://forums.phpfreaks.com/topic/51200-white-space-missing-in-text-database-field/ Share on other sites More sharing options...
chigley Posted May 13, 2007 Share Posted May 13, 2007 Paste the code which adds the values to the database please. Quote Link to comment https://forums.phpfreaks.com/topic/51200-white-space-missing-in-text-database-field/#findComment-252116 Share on other sites More sharing options...
Urbley Posted May 13, 2007 Author Share Posted May 13, 2007 <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); Quote Link to comment https://forums.phpfreaks.com/topic/51200-white-space-missing-in-text-database-field/#findComment-252131 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.