diff options
| -rw-r--r-- | search.php | 24 |
1 files changed, 21 insertions, 3 deletions
diff --git a/search.php b/search.php index be2607196..e680ae048 100644 --- a/search.php +++ b/search.php @@ -214,7 +214,7 @@ if (count($available_tags) > 0) $query = ' SELECT author, - COUNT(*) AS counter + id FROM '.IMAGES_TABLE.' AS i JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.image_id = i.id '.get_sql_condition_FandF( @@ -226,10 +226,28 @@ SELECT ' WHERE ' ).' AND author IS NOT NULL - GROUP BY author + GROUP BY author, id ORDER BY author ;'; -$authors = query2array($query); +$author_counts = array(); +$result = pwg_query($query); +while ($row = pwg_db_fetch_assoc($result)) +{ + if (!isset($author_counts[ $row['author'] ])) + { + $author_counts[ $row['author'] ] = 0; + } + + $author_counts[ $row['author'] ]++; +} + +foreach ($author_counts as $author => $counter) +{ + $authors[] = array( + 'author' => $author, + 'counter' => $counter, + ); +} $template->assign('AUTHORS', $authors); |