Query problems

Fotan

I have an application I'm writing that will take a list of people that have set up searches for a local MLS database, query the MLS database and email them new listings that match their criteria. I'm having a heck of a time with a nested query. I have included what I have so far...

//Start by getting the list of registered searches
$query = "SELECT * FROM searches";
$result = mysql_query($query)
or die ("Unable to get query data from database");
$nrows = mysql_num_rows($result);
for ($i=0;$i<$nrows;$i++)
{
$row = mysql_fetch_array($result);
extract($row); //Gives the search criteria for each row
//echo "<br>User $user_id - Search ID $search_id - Table $table - Price Range = $lprice-$uprice - $BEDROOMS Bed - $BATHS_TOT Bath - $ACRES Acres - Zip = $ZIP - City = $CITY - $SQFT sqft<br>";

//Query the MLS database with the paramaters from the search in the search table
$query2 = "select * from $table WHERE (CITY LIKE '$CITY' AND ZIP LIKE '$ZIP')";
//AND PRICE BETWEEN '$lprice' AND '$uprice'
//AND BATHS_TOT >='$BATHS_TOT' AND BEDROOMS >='$BEDROOMS'";
$result2 = mysql_query($query2)
or die ("Unable to query MLS database with query information from search table");
$nrows2 = mysql_num_rows($result2);
for ($j=0;$j<$nrows2;$j++)
{
echo "Table = $table - $LISTING_ID"; }

	} //End for loop - getting list of registered searches

When I echo the variables from the first query they are all there and properly formatted. When the second query goes off, it dies at the die statement.

Is there something obvious that I'm not seeing?!?

Thanks in advance for any help you can offer.

Matt

leatherback

Hi,

Have you echo-ed the query string?
Place a mysql_error() statement after your query, so you can actually see WHY it died.

Likely some var is not passed

Fotan

Thanks for the suggestion. I added a mysql_error() line directly after the second query and it blows right past it and still shows the die statement...

I'm guessing that you don't see anything wrong with my syntax in the second query?

When I echo the variables I'm using in the second query that come from the first query, they show up properly.

Thanks again.

leatherback

This is how to use the mysql_error() statement:

 $query2 = "select * from $table WHERE (CITY LIKE '$CITY)' AND (ZIP LIKE '$ZIP')";

$result2 = mysql_query($query2)
or die ("Unable to query MLS database with query information from search table". mysql_error());

PS: I do not use the like statement, I want exact matches, so I use

$query2 = "select * from $table WHERE (CITY '$CITY') AND (ZIP = '$ZIP')";

Fotan

Thanks. That got me over the hump. Now on the what I'm sure will be the next 5 problems...