From 4f6dabea73678e2dad683d160eef8fedc562e8c6 Mon Sep 17 00:00:00 2001 From: z0rglub Date: Fri, 5 Sep 2003 19:27:45 +0000 Subject: Correcting a bug in special categories (favorites, most seen, most recent... non numeric categories) : when a picture is linked to more than one category, it's only displayed once. git-svn-id: http://piwigo.org/svn/trunk@64 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_category.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'include/functions_category.inc.php') diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php index dffb6c337..33b3f92fc 100644 --- a/include/functions_category.inc.php +++ b/include/functions_category.inc.php @@ -493,9 +493,9 @@ function initialize_category( $calling_page = 'category' ) { $page['title'] = $lang['favorites']; - $page['where'] = ', '.PREFIX_TABLE.'favorites'; + $page['where'] = ', '.PREFIX_TABLE.'favorites AS fav'; $page['where'].= ' WHERE user_id = '.$user['id']; - $page['where'].= ' AND image_id = id'; + $page['where'].= ' AND fav.image_id = id'; $query = 'SELECT COUNT(*) AS nb_total_images'; $query.= ' FROM '.PREFIX_TABLE.'favorites'; -- cgit v1.2.3