Need a little help please.. .can't figure this out

[jamesojackson]

can't figure out why I'm getting an error here.. any of your help would be appreciated

I'm getting errors with both of these queries:

$querya = "SELECT AMOUNT FROM house_offers" .
"WHERE AMOUNT = $a3 AND HOUSEID='".$_GET['id']."' " ;
$resultsa = mysql_query($query_a);
$a4 = mysql_num_rows($resultsa);

	       $query_b= "SELECT AMOUNT FROM house_offers" .
		"WHERE AMOUNT => $b3 " .
		"WHERE AMOUNT < $a3 AND HOUSEID='".$_GET['id']."'  " ;
		$resultsb= mysql_query($query_b);
                   $b4=mysql_num_rows($resultsb);

Here is the error....

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

thanks in advance for your help!

[NogDog]

First, you didn't use the same variable name in the first query: $querya when you define it, but $query_a when you use it in the mysql_query() command.

Second, since that error indicates a query which could not be processed by MySQL, a useful pattern for debugging your queries is to do something like this:

$query = "SELECT blah blah blah";
$result = mysql_query($query) or die("Query failed ($query): " . mysql_error());