PHP - MySQL Error

[Ethan Hunte]

Hello People

I wonder if anyone could help me with this problem.

I am trying to run a formcheck error which looks for the user specified zone ($zone) in a table ($zones_table) to see if a row exists and my code is as follows :

if ( !defined('FRMCHK_USER') ) { die("Access Denied"); }

$fv = new formchecker;

<snip>

$inner = substr($zone, -3, 3);
$outer= substr($zone, 0, (strlen($zone)- 3));

$is_zone = $db->count_rows('zones_table', "WHERE outer='" . $outer . "'");

if ($is_zone == 0)
{
$fv->error_list[] = array('value' => $user_zone, 'msg' => MSG_NO_ZONE . ' (<b>' . $user_zone . '</b>)');
}

That said, I am getting a MYSQL error with the count_rows line. And I cannot work out why. Any help would be appreciated. The error code is as follows :

The query you are trying to run is invalid
Mysql Error Output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'outer='ZA5'' at line 1
SQL Query: SELECT count(*) AS count_rows FROM zones_table WHERE outer='ZA5'

Many thanks in advance

Ethan