Skip to main content
H
hamadtou
Participant
August 28, 2011
Question

Session varibales query

  • August 28, 2011
  • 1 reply
  • 243 views

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

This topic has been closed for replies.

1 reply

H
hamadtouAuthor
Participant
August 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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices