[SOLVED] PHP & MySQL use of Hyphen/Quotes in Data

[TRI0N]

Okay tried to search on this but how do I deal with Hyphen or Quotes in input fields?

 

Right now if I put in Event: Mike's Party

 

It will cause data entry problem.

[gluck]

use this mysql_real_escape_string()

[TRI0N]

So I'm taking that the following will work then?

 

mysql_query("INSERT INTO clients VALUES('NULL','$client_id','$l_name','$f_name','mysql_real_escape_string($event_name)')") OR die(mysql_error());

 

This will allow the correct input of a form for Event Name to be placed into the MySQL data field with the value of: Mike's Party

 

Rather then: Mike

MySQL Error?

 

Thanks I will give it a shot.

[atl_andy]

I think you'll need to read up on the syntax of mysql_real_escape_string.  It's what you need, but not how you have it.

[fenway]

So I'm taking that the following will work then?

 

mysql_query("INSERT INTO clients VALUES('NULL','$client_id','$l_name','$f_name','mysql_real_escape_string($event_name)')") OR die(mysql_error());

 

This will allow the correct input of a form for Event Name to be placed into the MySQL data field with the value of: Mike's Party

 

Rather then: Mike

MySQL Error?

 

Thanks I will give it a shot.

It's a PHP function... you can't pass it to mysql.