Project Detail

Description

I'll try to be as especific as possible. This should be fairly easy if you know what you're doing and should not take too long. I'm looking for this ASAP. Please bid ONLY after reviewing carefully what I'm asking for.

===============
Description
===============

I need a simple search form that will give 5 suggestions based on what's being typed. I'm looking for something very similar to google search suggestions in terms of look and functionality.

The suggestions will be queried from strings in a MySQL database using AJAX.

For each string/record in the db, The suggestions must be return in this format:

RecordID - ...(3 Previous words) <b>Keyword</b> (3 Previous words)...

Example:

String = "Hello there, this is a test string just for nothing"

If somebody is searching for the keyword 'test' the suggestion would be as follows:

ID#1 ...this is a <b>test</b> string just for...

string = 1 record in DB

Then this process will continue to 5 more records generating a total of 5 suggestions.

----------------------------------------------------------------
If there's more than one occurence of keyword in string
----------------------------------------------------------------

If there is more than one occurrency of the keyword in the same string (record), then the suggestions will be generated as the following sample:

String = "Hello there, this is a test string just for testing purposes and nothing else."

If somebody is searching for the keyword 'test' the suggestions would be as follows:

ID#1 ...this is a <b>test</b> string just for...
ID#1 ...string just for <b>test</b>ing purposes and nothing...

NOTE that in this case a single record returned two suggestions

Then the process will continue with other records for a total of 5 suggestions.


Requirements:

- AJAX
- PHP
- MySQL
- User must be able to move (navigate) between suggestions using the up/down keys.. See google search suggestions as example.
- Commented code - please use comments in your code

It is very likely I'll be contacting the winner for more similar projects if results are satisfactory.

Thnx


Additional information submitted:

10/25/2008 at 9:05 EDT:
Those asking for a db structure use this example:

-----------------------------------
ID | myString |
-----------------------------------
1 | This is a string |
-----------------------------------

BTW the suggestions in the suggestion box, when clicked, or entered, will redirect to a link (page.php?id=1).