#5 need to display records with a value that is >=12

[Anonymous]

Somewhere in thie below code I need to specify to only
list records that are of a value of 12 or higher for
$department

But I dont know how to do this....

Can anyone help??

Thanks

jeremy@aheadofmytime.com

if ($cmd =="List"){

### Get List of Open Jobs ###
$query = "SELECT DISTINCT id, department
from department, listing
WHERE department.id =
listing.fk_department";
$result = mysql_db_query($database, $query,
$connection) or die ("Error in query: $query. " .
mysql_error());

### Check each department ###

while(list($id, $department) = mysql_fetch_row
($result))