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"

[kickstart]

Hi

 

Should be easy to do, but will largely depend on your existing page.

 

You could check a database of counties and when the mysql_num_rows() is 0 put out a message or use a header redirect (eg header('Location:../ListCounties.php');).

 

Not really a MySQL issue though.

 

All the best

 

Keith

[erme]

Thanks for the prompt reply.

 

Sorry didn't mean to post here. Will repost it in PHP section.

 

I'm very new to PHP, how can I check the counties in the database?

[kickstart]

Hi

 

It is likely to be simple but would need more info on your current system / database tables to say.

 

In simple terms:-

 

$sql = "SELECT County FROM CountiesTable WHERE CountyName = '".mysql_real_escape_string($_REQUEST['county'])."'";
$result = mysql_query($sql,$conn) or die(mysql_error()." $sql");

if ($row = mysql_fetch_array($result))
{
// County found so all OK.
}
else
{
header('Location:../ListCounties.php');
}

 

All the best

 

Keith

[erme]

Thanks Keith,

 

I managed to get it working with this

 

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