aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2003-09-05 19:27:45 +0000
committerz0rglub <z0rglub@piwigo.org>2003-09-05 19:27:45 +0000
commit4f6dabea73678e2dad683d160eef8fedc562e8c6 (patch)
treef650fad5fcac6e6639bb027e8a5e8b587deb7356 /include
parent839771e0b692ebf468fcfbecec95d6e27c439394 (diff)
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
Diffstat (limited to '')
-rw-r--r--include/functions_category.inc.php4
1 files changed, 2 insertions, 2 deletions
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';