Could use any help you could give...thanks in advance

[jamesjackson]

could use any help that you could offer. can't figure out why I'm getting this error. just learning php/mysql.

Query failed (): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '=> '' WHERE AMOUNT < '' AND HOUSEID='196'' at line 1

here's my code:

$querya3= "SELECT a3 FROM house_listings WHERE HOUSEID='".$_GET['id']."' " ;
$a3= mysql_query($querya3);

$queryb3= "SELECT b3 FROM house_listings WHERE HOUSEID='".$_GET['id']."' " ;
$b3= mysql_query($queryb3);

===================================

no errors from above --- just below

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

[Protato]

minor problems to fix in your query:
-The correct syntax is '>=', 'Greater than or equal to'.
-Any where condition after the first is proceeded by 'AND', not another 'WHERE'

You might also want to consider escaping your variables before use in the query.

<?
//corrected query with escaped value
$id = mysql_real_escape_string($_GET['id']);

$query_b= "SELECT AMOUNT FROM house_offers" .
"WHERE AMOUNT >= '$b3' " .
"AND AMOUNT < '$a3' AND HOUSEID='".$id."' " ;
$resultsb= mysql_query($query_b) or die("Query failed (): " . mysql_error());
$b4=@mysql_num_rows($resultsb);
?>