Forms, php and SQL Queries... help needed for a newbie :-)

loopynutter wrote: I have a form with dropdown lists forf the user to choose from, I use the POST method to pass this information to a results.php page. On the results.php I have created a dynamic table to display the results, where I'm having problems is using the Recordset to display the right query... using the WHERE command. It works when I do a single query on one of the fields, (using the Simple section of the recordset popup), but this now only seems to work when I click Test... when I publish the page no results are returned.

If you're using the POST method, you need to set the filter to use Form Parameter.

2nd problem is then the SQL code for returning records based on more than 1 criteria. I'm getting myself a bit confused reading the the Dreamweaver help with variables etc, and which I should be using, and do I have to define them or is it automatic?... and whats 'colname;??

You need to define the variables yourself. Colname is simply the generic name that Dreamweaver gives to a variable that's generated automatically in Simple mode. The following screenshot from my book, "The Essential Guide to Dreamweaver CS4 with CSS, Ajax, and PHP", shows a SQL query that uses two variables that I have called var1 and var2.

As you can see, I have defined the values for var1 and var2 in the Variables field by clicking the plus button. You need to set the name, type, default value, and runtime value. You can call the variables anything you like, as long as they don't clash with your table or column names, or use MySQL reserved words.