Almost there...

1 files changed, 14 insertions, 3 deletions

diff --git a/dash/dash_employee.php b/dash/dash_employee.php
index 795d400..df7112d 100644
--- a/dash/dash_employee.php
+++ b/dash/dash_employee.php
@@ -2,9 +2,20 @@
 if (!defined('HEIRARCHY')) die;
 $title = 'Dashboard / Bulletin';
 require('header.php');
-$page = 1;
-// if (!empty($_GET['p'])) $page = max(1, intval($_GET['p']));
-$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated WHERE ads.closed = 0 GROUP BY ads.id LIMIT ' . $b_config['ads_per_page']*($page-1) . ', '.$b_config['ads_per_page']) or fatal($db->error);
+$result = $db->query('SELECT id, cat_name FROM categories') or dash_fatal($db->error);
+?>
+      <form id="viewform" action="/dash/" method="get">
+        <p>Show Me: <select id="catchanger" name="cat" onchange="this.form.submit();">
+          <option<?php if (empty($_GET['cat'])) echo ' selected="selected"';?> value="0">All Categories</option>
+<?php
+while ($row = $result->fetch_assoc()) echo '          <option'.((intval($_GET['cat'])==$row['id'])?' selected="selected"':'').' value="'.$row['id'].'">'.htmlentities($row['cat_name']).'</option>'.PHP_EOL;
+$result->free();
+?>
+        </select></p>
+      </form>
+<?php
+$catstr = empty($_GET['cat']) ? '' : ' AND cat = '.intval($_GET['cat']);
+$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated WHERE ads.closed = 0'.$catstr.' GROUP BY ads.id LIMIT 0, '.$b_config['ads_per_page']) or fatal($db->error);
 while ($row = $result->fetch_assoc()) draw_ad($row);
 $result->free();
 require('footer.php');