[PHP-DB] Special character on an INSERT statement

[Jorge Giménez Mayorgas]

Hi .

I'm trying to do this on an INSERT statement. 

$sql= "INSERT .... (' TONS OF CD'S ')
or any phrase with the character ' .
Obviously it gives an error when execeting mysql_query.

How can I do it ?

Thanks,

            Jorge Giménez