Hi People,

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'); ?>

<?php
    if($_POST_VARS["bed_option"] == "Less than")
    {
        $bComp = "<";
    }
    else if($_POST_VARS["bed_option"] == "More than")
    {
        $bComp = ">";
    }
    else
    {
        $bComp = "=";
    }
?>

<?php
mysql_select_db($database_rsSearch, $rsSearch);
$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);
?>