Changeset 64 for trunk/include/functions_category.inc.php

Timestamp:

Sep 5, 2003, 9:27:45 PM (21 years ago)

Author:

z0rglub

Message:

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.

File:

• trunk/include/functions_category.inc.php (modified) (1 diff)

trunk/include/functions_category.inc.php

@@ -494 +494 @@
         $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';