Apostrophe's in database entries

[Mr_Mako]

Hi...

I'm having a problem whenever someone enters an entry into the database where the name has an apostrophe or quotes in it. I am using the database entries as links to specific information about that particular field entry.

An example of the 'links' I am creating for my database are below:

$plane_name_long = $row['name'];
$plane_name_fix = str_replace(" ", "%20", $plane_name_long);
$plane_link = "<a href=aircraft.php?name=$plane_name_fix><font color=#30341B><b>$plane_name_long</b></font></a>";

Now, if someone creates a plane and calls it Daddy's Boys, the link will only show Daddy.

Like wise, if the same thing is done with quotes.

Is there a way around this?

[LordShryku]

Tried [man]mysql_escape_string[/man]?

[Pig]

You can also use add_slashes() or (even better) html_special_chars() when inserting the data.