strange PHP/MySQL problem

From: Date: Sun, 28 Jan 2001 04:06:03 +0000
Subject: strange PHP/MySQL problem
Groups: php.general 
Request: Send a blank email to php-general+get-37082@lists.php.net to get a copy of this message
if you goto http://downloads.moddingcentral.com/add.php you will see a simple form this form takes the info and a PHP script processes it and places it into a mysql table. now the problem if i put Cynical Saint's Video Tutorial in the name it will display Cynical Saint\ in the dbase (also seen @ downloads.moddingcentral.com) but if you place it in the description it is fine.. here is my sql query $rst = mysql_query("INSERT INTO tablename(id, game, section, name, size, description, dllink, creator, creatoremail, date, website, score, downloads) VALUES ('$id', '$game', '$section', '$modname', '$size', '$description', '$dllink', '$creator', '$creatoremail', now(), '$website', '0', '0') ") or die(mysql_error()); Whats wrong with this? its driving me nuts! - Thanks

« previous php.general (#37082) next »