extract ($_POST);
echo '<input name="idNumber" type="hidden" id="idNumber" value="'.$idNumber.'" />';
$query = "UPDATE $housesTable SET price='".$price."',type='".$type."',address='".$address."',city='".$city."',state='".$state."',zip='".$zip."',apt='".$apt."',description ='".$desc."',area='".$area."',status'".$stat."' WHERE house_id='".$idNumber."'";
mysql_query($query) or die("SQL ERROR <br />".mysql_error());
returns
SQL ERROR
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 ''2' WHERE house_id=''' at line 1
Can anyone help me out?
Thanks for your time
~Gabor Szauer