fetching data having apostophe from mysql

[mailtome]

Hi
I am fetching record from a mysql table.
One of the entries contain a apostophe
eg. test's
But it gives this error
mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[mailtome]

What I am doing is
I fetch data from table & fire another query using that data.
eg.
$desc=mysql_query("SELECT description from table1.....");
$desc=mysql_fetch_array($desc);
&then after fetching description I fire another query
mysql_query("SELECT ........where description='$desc[0]');
If description contains an apostrophe then the error occurs

[harlowhair]

mysql_query("SELECT ........where description='$desc[0]'); 

Your query needs a closing speech mark - however I'm guessing you have that in the original code...

Try changing the query to:

mysql_query("SELECT ........where description='" . addsalshes($desc[0]) . "'"); 

This will automaticaly add escape characters to anything that may mess up your query (such as apostrophes).