Data entered no going into database

[rfigley]

I have a form, submitting data to the database, and all is going in except for paragraph_1. No errors. Just the text won't go in the database.

Here's the HTML form to enter the data:

 <input name="newsletter_title" size="100">
 <input name="newsletter_title2" size="100">
 <textarea name="paragraph_1" cols="75" id="paragraph_1"></textarea>
  <textarea name="paragraph_2" cols="75" id="paragraph_2"></textarea>

Here's the command inserting into the table:

 
$sql = "INSERT INTO tbl_newsletter_sections (newsletter_title,newsletter_title2,paragraph_1,paragraph_2)
   VALUES ('$newsletter_title','$newsletter_title2','$paragraph_1','$paragraph_2')";

[nemonoman]

2 suggestions

add slashes
$text1=addslashes($paragraph_1);

If your sql code is actually

'$paragr
aph_1',

Then the problem is in the line breaking the name of the variable. You can prove this guess by looking in the records and seeing whether you have "aph_1" where $paragraph_1 ought to be.

[rfigley]

No actually the break is only here, not in the acualt code being used.

Not clear though about the addslashes?