How to write SQLquery with escapes special characters in a string

The mysql query will not allow the entry which has single qoutes in it.
For example if you want to insert the name O’brain from a form to database.
then use “mysql_real_escape_string” for inserting the name as it is.
For more detail see this page.
http://php.net/manual/en/function.mysql-real-escape-string.php