Creating a simple database search

[John_B_Design]

Hi

I'm being dragged kicking and screaming into site development by the needs of an important customer, and I'm trying to create a very simple search of a database.

I'm using DW CS4 with PHP & MySQL on a Mac (Leopard) using MAMP.

I've set up two pages for the task.

1) a HTML page with a form using the 'GET' method
2) a PHP page with the Recordset to filter 'postcode' 'begins with' using the 'URL Parameter' and 'postcode', and sort by 'company' 'Ascending'

Running a test in the Recordset works great.

When testing in a browser however (Firefox and Safari), the post code appears in the URL string when arriving at the results page, but no results show.

When I don't apply a filter in the Recordset, all records display in the results page perfectly.

I'm going even more grey (gray?) so any help and advice would be greatly appreciated.

Many thanks.

[John_B_Design · Accepted solution]

I've sorted it.