Re: strange PHP/MySQL problem

Are you adding slashes beforehand (or running magic quotes) ? Also I always do a stripslashes() on the text fields I print out. --Joe On Sat, Jan 27, 2001 at 11:06:03PM -0500, PeterOblivion@aol.com wrote: > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Joe Stump, PHP Hacker joestump98@yahoo.com http://www.miester.org/