Best way to submit text into MySQL?

[DaveLinger]

I'm beginning to run into some SQL problems... I have a text area in which the user can enter text and upon submission it is added to a "text" column in my mysql db. The problem is quotes (among other things) screw it up. How can I get around that?

[kenrbnsn]

Use the function mysql_real_escape_string() on all text fields that will be stored in a MySQL database. (http://www.php.net/mysql_real_escape_string)

Example:
[code]<?php
$q = "insert into yourtable set fieldname1 = '" . mysql_real_escape_string($your_variable) . "'";
$rs  = mysql_query($q) or die("Problem with query: $q<br>" . mysql_error());
?>[/code]

Ken