Another Mistake (in Search System)...Is it me?
I am trying to build the search system described in Chapter 8 and when I get to the point where I need to add the variables (bComp,<,$bComp) I get the following error when I click OK (the code isn't added to the page):
"bComp is an invalid variable name; it does not appear in the SQL"
Can someone pleeeeeeeease help. I am so frustrated and don't know if it is me or the *&^( book!
<?php require_once('Connections/rsSearch.php'); ?>
if($_POST_VARS["bed_option"] == "Less than")
$bComp = "<";
else if($_POST_VARS["bed_option"] == "More than")
$bComp = ">";
$bComp = "=";
$query_Recordset1 = "SELECT ID, price, bed FROM room";
$Recordset1 = mysql_query($query_Recordset1, $rsSearch) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);