apostrophe problem

[java12]

I have a problem comparing surnames from different MySQL tables when the surname field has an apostrophe like O'Neill.

 

The surname from table1 is stored as $name and the surname is selected when it matches the surname field in table2. The lines below work fine until an apostrophe appears.

 

I have tried various things like mysql_real_escape_string, which worked on another issue, but not here. Can anyone suggest where I'm going wrong?

 

<?php
			  
			 // $name is the surname field in table1

			 $query = mysql_query("SELECT * FROM table2 WHERE surname='$name'");
			 while ($row = mysql_fetch_array($query))  {
			 echo "$name<br>";

			 }   

			?>

[chigley]

http://uk.php.net/addslashes

http://uk.php.net/stripslashes

 

Add the slashes before inserting into the database, and remove them when outputting them.

 

[java12]

Thanks, but how would you do it when the table1 surname field is already populated?

[chigley]

Not much you can do really, other than edit them/make a script to edit them yourself.