dreamweaver & php/mysql

[ripetungi]

I am using Dreamweaver MX on OS X, and trying to built a search page (with drop down menus and sumbit button) using php and sql. Have followed the help files in dreamweaver to the letter, whereby I have created a sql connection to my sql database (connection made). And then I have created a recordset to connect to the database on the results page (can see the data within), however this is the problem. When creating the recordset (pop up menu) and adding sql statement through the simple options, using either the url paramer or form varible, and using the form from the search page created earlier, when I test the recordset in the panel and try the different values from the database, I get the results that I want. However, once I test the pages on my local apache server, I get no data returned from mysql database - have linked the two page from the search page, as the results page is displayed simple with the table there but no data in it. But when there is no sql statement in the recordset all the information is displayed, but there is no point to the search as want search value listed first in the results (address). Have tried playing with the GET and POST options in Dreamweaver, have tried the master detail page results (different question - how to link to individual pages from the results) but again no data returned with a sql statement from the search. have spend hours re-doing the recordset from the help files and searching the internet, but they all say the same thing which does seem to work. Cheers