I have two? tables that contain the following:
tbl1? - Names, Addresses, 1st part of post code,? 2nd part of post code
tbl2 - 1st part of postcode, County, Country, longitude, latitude
What I need....
SQl that will take the first part of the postcode that the user has entered and return the results within a certian radius that I can specify.
The results...
1. I will need to be able to page these i.e. <<Previous - 1 2 3 4 -Next>>.
2. I should be able to decide who shows on page one but have it ranomized.
3. Who shows on page two and after? (again, randomized)
4.? Who shows at the back of results.
I would like the SQL to be able to be dropped into Dreamweaver's recordsets (I'm using Interakt Pro).
Please let me know your offers.