Simple error message if not in database

[erme]

Hi, I currently have something like this:

 

/company.php?county=devon

 

but if, say, a user manually puts something like this in

 

/company.php?county=devvvon

 

I want it to display a message (possibly re-direct to another page) saying "County does not exist"

[Lamez]

$q = mysql_query("SELECT * FROM table WHERE name = '$name'");
$n = mysql_num_rows($q);
if($n > 0){
  echo $name;
}else{
  echo $name." not found.";
}

[erme]

Wow that simple! I feel like an idiot now, been pulling my hair out for past 2 hours! Thanks mate!!!