Changeset 636
- Timestamp:
- Dec 5, 2004, 10:35:04 PM (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/functions_category.inc.php
r634 r636 581 581 if ( isset( $forbidden ) ) $page['where'].= ' AND '.$forbidden; 582 582 583 $query = ' SELECT COUNT(DISTINCT(id)) AS nb_total_images';584 $query.= ' FROM '.IMAGES_TABLE; 585 $query.= ' INNER JOIN '.IMAGE_CATEGORY_TABLE.'AS ic';586 $query.= ' ON id = ic.image_id';587 $query.= $page['where'];588 $query.= ';';583 $query = ' 584 SELECT COUNT(DISTINCT(id)) AS nb_total_images 585 FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic 586 ON id = ic.image_id 587 '.$page['where'].' 588 ;'; 589 589 } 590 590 // categories containing recent pictures
Note: See TracChangeset
for help on using the changeset viewer.