php not passing variables

[xenok]

Hi, I've got a mysql database connected to an html content management page and a flash movie via php.

Problem is that the form inputting the info into the database is not passing variables, but only sometimes.

EG.

"Hello World" works ok but "Hi, I'm Will Bithell" doesn't!🙁

I'm using the POST method to pass variables.

The field to hold the text is set up as LONGTEXT, NOT NULL, but it appears to hold any data I want it to when inputted from PHPMyAdmin.

Any help would be greatly appreciated.

[laserlight]

Give the smallest code snippet that exhibits this problem.

[xenok]

$result=mysql_query("SELECT $hometext FROM $table WHERE id = '1'");

$text=mysql_result($result,$hometext);

?>
Update Home Text:
<form name="form1" method="post" action="homeupdateprocess.php">
<textarea name="ud_hometext" cols="50" rows="10"><? echo "$text"?></textarea>
<input name="Submit" type="Submit" value="Update">
<br>
</form>
</p>
<?

[onion2k]

Originally posted by xenok
"Hello World" works ok but "Hi, I'm Will Bithell" doesn't!🙁

At a guess, you have magic quotes switched off, you're using single quotes in SQL and you're not using addslashes() on the text going into the update statement. So that ' in "Hi, I'm Will Bithell" is breaking the SQL statement.

[xenok]

makes sense, but I'm really new to this, how do I rectify this?