I am looking for a PHP and MySQL genius to build me a simple but accurate search script! The script will be used to return information about a specific topic or question to the user which they define.
I need to be able to define exactly which terms I want each result in the database to appear for. The script should display the result from the database which matches the user's query exactly. If no results match exactly, then I need the script to deliver the best closest result. It's not just a case of displaying a similar result, the absolute closest match must be returned. If a close enough match cannot be found then nothing should be returned.
The code written must be optimized for speed in execution and written in it's simplest form.
My budget for this is low as I know this is not a difficult task. There will definitely be bigger jobs in the future for the developer I choose if the project is completed successfully.