Changeset 6653 for branches/2.1/include/ws_functions.inc.php
- Timestamp:
- Jul 3, 2010, 2:16:12 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.1/include/ws_functions.inc.php
r6501 r6653 286 286 287 287 $query = ' 288 SELECT i.*, GROUP_CONCAT(category_id) cat_ids288 SELECT i.*, GROUP_CONCAT(category_id) AS cat_ids 289 289 FROM '.IMAGES_TABLE.' i 290 290 INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON i.id=image_id … … 694 694 695 695 $query = ' 696 SELECT COUNT(id) nb_comments696 SELECT COUNT(id) AS nb_comments 697 697 FROM '.COMMENTS_TABLE.' 698 698 WHERE '.$where_comments; … … 1455 1455 { 1456 1456 $query = ' 1457 SELECT image_id, GROUP_CONCAT(tag_id) tag_ids1457 SELECT image_id, GROUP_CONCAT(tag_id) AS tag_ids 1458 1458 FROM '.IMAGE_TAG_TABLE.' 1459 1459 WHERE tag_id IN ('.implode(',',$tag_ids).')
Note: See TracChangeset
for help on using the changeset viewer.