Jump to content


Photo

MySQL query problem, maybe bug


  • Please log in to reply
1 reply to this topic

#1 eric

eric
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 08 January 2003 - 03:57 PM

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.

#2 delamitri

delamitri
  • New Members
  • Pip
  • Newbie
  • 7 posts
  • LocationUK

Posted 08 January 2003 - 04:04 PM

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/m....addslashes.php for other ways of formatting text for database and urls.

Hope this helps

Kevin[/code][/url]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users