Php / Sql Search Script 16.09.08
Hello,
I need a search script re-created from our current search script.
The current script isn’t functioning correctly and the ‘Suburbs’ table doesn’t hold the correct data to perform an accurate search.
You will first need to re-create and populate the table ‘Suburbs’ from the csv attached. (id,suburb_name,state,postcode)
Members of our website all have a ‘profile’ in the db. The profile tables structure can be seen in the attached file.
Clients pay to have their profile added to the website. They can select up to 3 postcodes to be listed under in searches. They also get found through the ’state’ and ‘city’ matched to their postcodes (pcode1, pcode2 or pcode3)
Basically the search feature needs to perform the following tasks…..
1. perform a search based on the state a user clicks “show all’.
2. allow for users to search via postcode or suburb name.
3 echo results as seen in current script – directory-search.php.
Please pm me if you have any questions.
Thanks
