From 267c1c63a2e77ce74c41254e2f1a215b1f52e306 Mon Sep 17 00:00:00 2001 From: nikrou Date: Sat, 3 Jul 2010 12:20:38 +0000 Subject: Bug 1755 : Needs single quotes in queries official plugins git-svn-id: http://piwigo.org/svn/trunk@6654 68402e56-0260-453c-a942-63ccdbb3a9ee --- picture.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'picture.php') diff --git a/picture.php b/picture.php index 2aa28f886..2fae0cda4 100644 --- a/picture.php +++ b/picture.php @@ -52,9 +52,9 @@ SELECT id, file, level else {// url given by file name assert( !empty($page['image_file']) ); - $query .= 'file LIKE "' . + $query .= 'file LIKE \'' . str_replace(array('_','%'), array('/_','/%'), $page['image_file'] ). - '.%" ESCAPE "/" LIMIT 1'; + '.%\' ESCAPE \'/\' LIMIT 1'; } if ( ! ( $row = pwg_db_fetch_assoc(pwg_query($query)) ) ) {// element does not exist -- cgit v1.2.3