Using addslashes with mysql

[mdowling]

When I add in an entry to a table using addslashes, I can't select that entry from the table. Here is my problem

I have this: "Weaver's bottom"
convert it to: "Weavers\'s bottom" using addslashes,

then when I run this query:
"SELECT * FROM words WHERE word = 'Weaver's bottom"

I get no results... Then I tried:
"SELECT * FROM words where word = \"".$showword."\""

($showword is Weaver\'s bottom) but still nothing....

Anyone know what's wrong?

[devinemke]

$showword = "Weaver's bottom";
$result = mysql_query("SELECT * FROM words where word = '" . addslashes($showword) . "'") or exit(mysql_error());