Storing wrong value in MySQL

Jon12345

I am getting an odd error. I have a form that submits values to a MySQL database. However, there are two fields that are not being submitted correctly. They are Text fields in the MySQL database as opposed to VARCHAR fields for the rest of them.

On my Form, I have single line text fields for everything except these two fields, which are multi line. So, it must be one of these that is causing the problem.

The problem is that instead of getting just the data stored in the MySQL database, I am getting all this stored:

value="this is a test phrase"

...instead of just... this is a test phrase

Any ideas?

A sample of my form code follows:

      <td valign="top">Artitle Title</td>
      <td><input name="TopicTitle" type="text" id="TopicTitle" size="50"></td>
    </tr>
    <tr> 
      <td valign="top">Article Body</td>
      <td><textarea name="TopicBody" cols="50" rows="8" id="TopicBody"></textarea></td>
    </tr>

mrhappiness

you really think anyone can help you without knowing how you store the data and how you output it? 🙂

Jon12345

Yes I did! 😃

Ok, so here is the page that sends the data to MySQL. Anything wrong here?

<?
$dbh=mysql_connect ("localhost", "alwaysac_Jon", "Angie") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alwaysac_MyArticles"); 
mysql_query("insert into Articles(TopicName, MetaTitle, MetaDesc, TopicTitle, TopicBody, Advert) values('$TopicName', '$MetaTitle', '$MetaDesc', '$TopicTitle', '$TopicBody', '$Advert')"); 
mysql_close($dbh);

header("Location: /pealist.php"); 
?>

mrhappiness

should work under normal circumstances 🙂

what about the output?

Jon12345

I am looking directly at the data via phpMyAdmin so the output won't affect it.

The only difference I can see is as previously stated.

mrhappiness

what did you enter?

Jon12345

Just narrowed it down. It only happens when I go to my Edit page. So its something there.

Quick question: Is there any difference between a multi-line text field and a text area? I am looking at the toolbar in dreamweaver.

Jon12345

I think it is something to do with how I am trying to set a value for the textarea. It doesn't like the way I have done it. Where I have put value=blah blah, it is storing the whole thing including "value="blah blah". Whereas in the text field it only stores the actual string that is set to value.

Any tips of how to change it?

Jon12345

Got my answer! I was not closing my text area tags

needs to be