AND problems

[gobbles]

Hey Peoples,

I am running a query of mine against my database which is as follows:

  $searchquery = "SELECT advertisers.venue_name, advertisers.id FROM listings, advertisers WHERE advertisers.state = '$state' AND advertisers.region = '$region' AND listings.active = 1 AND advertisers.active = 'Yes' AND listings.$flavour = 1";
  $searchresult = mysql_query($searchquery) or die ("Error:". mysql_error());  						     

  $searchcount = mysql_num_rows($searchresult);

I cant see any problems with this, but its returning 2 results instead of 1 ... I know there is only 1 result that matches all of the conditions in the query.

If anyone can see anything wrong, could they please let me know.

Thanks Muchly

[NogDog]

I don't see anything semantically wrong. To debug, I'd suggest you print out the $searchquery variable after you define it, then after the query loop through both records and output their contents. This should help you determine if there is a logic error, a data error, or a typing error (e.g.: maybe one of the variables you're using in the query isn't set to the value you think it is).