What's wrong with this code?

bmopro

Hello,

After this code i have the mysql_quert INSERT. When i remove this code, it INSERTs fine. When i put it back in, It gives me no errors and and doesn't insert anything...
I can't fiure out why!? It seems pretty striaght forward.
Thanks for the Help!!
Brian

Here is the code:
$sql_bar_check = mysql_query("SELECT bar_name FROM bar_directory
WHERE bar_name='$bar_name'")or die (mysql_error());
$sql_address_check = mysql_query("SELECT address FROM bar_directory
WHERE address='$address'")or die (mysql_error());

$bar_check = mysql_num_rows($sql_bar_check)or die (mysql_error());
$address_check = mysql_num_rows($sql_address_check)or die (mysql_error());

if(($bar_check > 0) && ($address_check >0)){
echo "This Bar has been registered by someone else. If you feel this is<br> an error, please complete the form below to report it.";

unset ($bar_name);
unset ($address);

include 'bar_info.html'; // Show the form they can report error! 
exit();  // exit the script so that we do not create this account!

thorpe

where are the variables $bar_name and $address being defined? and why are you running two queries on the same table when they could easily be done with one?

you are also unsetting these variables, do you need them for the insert?

bmopro

The variables are being defined by a form that is submited.
I want to check and make sure no one else had registered the same bar.
This is the way that made sense to me. Make a query and see if the value of the
mysql_num_rows is > 0, therefore the name has been registered.

'why are you running two queries on the same table when they could easily be done with one? '

Cuz I'm a n00b, I'll change it.
Thanks for your help and patience!
Brian