Session varibales query

Report · Aug 28, 2011

Hi,

I am newbi,

I had multipage forms. the first form contain Triptype(dropdown), Airport(dropdown) and Zipcode(dropdown). I can pass these variable to second page form. but I need to query the database according to tow session variable say airport and zipcode, I have a table called price with zipcode, airport and price$. I need to show the results and take the results to the 3rd form .........

could any body help me with that, I am using dreamweaver cs3

Many thanks

Report · Aug 28, 2011

one more, I can use recordset query but I can only make filter to one variable, some thing like this

mysql_select_db($database_connlimobooking, $connlimobooking);
$query_res = sprintf("SELECT * FROM price WHERE zipcode = %s", GetSQLValueString($colname_res, "int"));
$query_limit_res = sprintf("%s LIMIT %d, %d", $query_res, $startRow_res, $maxRows_res);
$res = mysql_query($query_limit_res, $connlimobooking) or die(mysql_error());
$row_res = mysql_fetch_assoc($res);

how can add the second session variable (airport) query statement