Fix bug 1733 : queries must use single quotes

git-svn-id: http://piwigo.org/svn/trunk@6589 68402e56-0260-453c-a942-63ccdbb3a9ee
Piwigo · Jun 23, 2010 · 186e9df · 186e9df
1 parent 1015546
commit 186e9df
Showing 1 changed file with 4 additions and 4 deletions.
diff --git a/include/functions_comment.inc.php b/include/functions_comment.inc.php
@@ -156,11 +156,11 @@ function insert_user_comment( &$comm, $key, &$infos )
 INSERT INTO '.COMMENTS_TABLE.'
   (author, author_id, content, date, validated, validation_date, image_id)
   VALUES (
-    "'.$comm['author'].'",
+    \''.$comm['author'].'\',
     '.$comm['author_id'].',
-    "'.$comm['content'].'",
+    \''.$comm['content'].'\',
     NOW(),
-    "'.($comment_action=='validate' ? 'true':'false').'",
+    \''.($comment_action=='validate' ? 'true':'false').'\',
     '.($comment_action=='validate' ? 'NOW()':'NULL').',
     '.$comm['image_id'].'
   )
@@ -352,7 +352,7 @@ function validate_user_comment($comment_id)
 {
   $query = '
 UPDATE '.COMMENTS_TABLE.'
-  SET validated = "true"
+  SET validated = \'true\'
     , validation_date = NOW()
   WHERE id = '.$comment_id.'
 ;';