Advanced recordset and variables

[milou2007]

Hi, I'm new to the forum and also a beginner in programming.
I'm using Dreamweaver 8 and PHP Myadmin 2.9.2 with Wamp.
What would be the correct SQL query and variables to put in an adanced recordset in the following case:
My web site (under construction) offers the opportunity to look for vacations.
I would like to retrieve the date stored in the database and to show the results of the user's search when they choose a state plus a city (in another words-sorry for my English - retrieve the date from the Db when it matches the criteria elected in the list/menu)

The documentation from Dreamweaver points "$_GET['state'] Also I was told to put #state# but nothing works.
Thanks very much for any helpHi, I'm new to the forum and also a beginner in programming.

Thanks very much for any help
Milou2007
:(

[landslide]

try postng this to the Sql area youll get a response there.

[milou2007]

Thanks for the answer anyway.
Although I am now dealing with SQL and ASP instead of MySql and Php, I belive the following links may help those who are looking to retreive data using DW8 or MX.
1 - If the search/results page set always returns the same record: here it is:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_15761
2 - To Create client-side dynamic dependent list boxes in ASP , this one:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?event=view&id=KC.tn_19117&extid=tn_19117&dialogID=11198508&iterationID=2&sessionID=483095bfe265481b4f18&stateID=0+0+11194664&mode=simple#vbsource

Back to the question I put, the SQL query for the advanced recordset must be set this way:
SELECT * FROM table WHERE table_column_id = vartable_column
and then the value set to an existing value and the run-time value like this: Request("yourform")
Hope this may be of some help ... because it also have to do with Dreamweaver