Jump to content

Archived

This topic is now archived and is closed to further replies.

eric

MySQL query problem, maybe bug

Recommended Posts

my query:

 

$query = \"INSERT INTO $whattype1 (id, title, description, size, category, bywho, uname, boxurl, urls, type, dateadded) VALUES (\'\', \'$title1\',\'$description1\',\'$size1\',\'$category1\',\'$bywho1\',\'$uname1\',\'$boxurl1\',\'$urls1\',\'$type1\',\'$datetime\')\";

 

it works but if I try to use \' or , in the description it gives errors, it\'s because in the query, it uses \' and , seperate.

Share this post


Link to post
Share on other sites

Its because of the \', the commas wont affect it.

 

When adding texual data into the database, its a good idea to use addslashes and when retreiving it back out, use stripslashes.

 

so for instance you should use:

 

$query = "INSERT INTO $whattype1 (id, title, description, size, category, bywho, uname, boxurl, urls, type, dateadded) VALUES (\'\', \'".addslashes($title1)."\',\'".addslashes($description1)."\',\'$size1\',\'$category1\',\'$bywho1\',\'$uname1\',\'$boxurl1\',\'$urls1\',\'$type1\',\'$datetime\')"; 

 

 

See http://www.php.net/manual/en/function.addslashes.php for other ways of formatting text for database and urls.

 

Hope this helps

 

Kevin[/code][/url]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.