From 964f9774015525f3cfe4e10509744f6c4494e782 Mon Sep 17 00:00:00 2001 From: plegall Date: Sun, 5 Dec 2004 21:35:04 +0000 Subject: bug fix on typo git-svn-id: http://piwigo.org/svn/trunk@636 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_category.inc.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php index 7542e337a..0a718b79e 100644 --- a/include/functions_category.inc.php +++ b/include/functions_category.inc.php @@ -580,12 +580,12 @@ SELECT COUNT(DISTINCT(id)) AS nb_total_images $page['where'].= date( 'Y-m-d', $date )."'"; if ( isset( $forbidden ) ) $page['where'].= ' AND '.$forbidden; - $query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_images'; - $query.= ' FROM '.IMAGES_TABLE; - $query.= ' INNER JOIN '.IMAGE_CATEGORY_TABLE.'AS ic'; - $query.= ' ON id = ic.image_id'; - $query.= $page['where']; - $query.= ';'; + $query = ' +SELECT COUNT(DISTINCT(id)) AS nb_total_images + FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic + ON id = ic.image_id + '.$page['where'].' +;'; } // categories containing recent pictures else if ( $page['cat'] == 'recent_cats' ) -- cgit v1.2.3