insert help

[darkfreaks]

what would cause

 

$this->messages 

to break when inserted into the database when i insert don't i get "error inserting don't into the database"

 

Note i have used dots to escape the insert

 

[darkfreaks]

 

wont' insert single quotes:

$insert_message = mysql_query("
           	 	insert into chat_messages (user, type, content, pm_user, location)
           	   	values
           	   		(
           	       '$poster',
           	       '$type',
           	        '".$this->message."',
           	        '$pm_user',
           	        '$location'
           	    	)
           		");

[darkfreaks]

fixed i used:

$this->message = str_replace("'","''",$message);