2009-11-29T12:35:09Z FluxBB http://www.jobberbase.com/forum/topic2081-help-with-a-function.html Hey you're awesome! Missed that somehow ... thanks so much for the quick reply =) milezteg 2009-11-29T12:35:09Z http://www.jobberbase.com/forum/post7706.html#p7706 Hi! To achieve what you want, open _includes/class.Job.php and find this function GetJobsCountPerCity. Inside it, you'll see if ($count > 0). Change 0 to whatever value you wish (if you want at least 2 jobs, then change 0 to 1). Please note that 'Sidebar - show only cities with jobs' must be set to yes for this to work correctly. putypuruty 2009-11-27T17:21:38Z http://www.jobberbase.com/forum/post7684.html#p7684 In the sidebar on the home page you can see a list of all jobs in all cities. I have a huge list of cities so I am trying to shorten this list a bit by only showing cities with at least 2 jobs in them. Here is the function: [code] public function GetNumberOfJobsInOtherCities() { global $db; $sql = 'SELECT COUNT(id) AS total FROM '.DB_PREFIX.'jobs WHERE is_temp = 0 AND is_active = 1 AND city_id IS NULL'; $result = $db->query($sql); $row = $result->fetch_assoc(); return $row['total']; }[/code] I have tried a lot of things but I not a SQL guru. The following did not work: [code]$sql = 'SELECT COUNT(id) AS total FROM '.DB_PREFIX.'jobs WHERE is_temp = 0 AND is_active = 1 AND city_id IS NULL GROUP BY id HAVING total > 3';[/code] Any ideas guys?? milezteg 2009-11-27T09:43:40Z http://www.jobberbase.com/forum/post7679.html#p7679