Session varibales query

Question

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 cs3Many thanks

hamadtou · Answer

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded