MySQL Error when checking for duplicate emails

Hi All,

I’m not using the membership plugin for this client.

When a "create a new record" form is submitted, I’m trying to check for duplicate email addresses in a table called publicity_listings using  mysql_select_count_from with this code:

  // check for duplicate email
   $count = mysql_select_count_from('publicity_listings', "'".mysql_escape($_REQUEST['email_address'])."' IN (email_address)");
 if ($count > 0 ) { $errorsAndAlerts .= "That Email Address already exists.\n";
 }

but when I submit the form I’m getting this error and I don’t know how to remedy the issue.

mysql_count() MySQL Error: Table 'jeannes_ds.cms_publicity_listings' doesn't exist (at old_alias_functions.php line 6 in function mysql_count)

I’d eventually like to redirect the visitor to an update page that shows the information from the duplicate record, but need to get this resolved first.

I've attached the entire viewer in case it's of some help.

Thanks,

Jerry Kornbluth