How to fetch and display the records of various fields from database on the click of records of one field fetched from database with the help of ajax?

can u help me with the simple ajax application in which i am showing records of 1 field from database and on the click of that , its details are shown with ajax.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I once wrote a very simple ajax script that should help you get started.

All you would go is modify the php file to return your results from your database instead of what the example is returning. This is the most simple ajax tutorial I know of:

The script can take whatever if types into those fields and can do anything in php with it. So if you type a 1 you could make it look up record #1 in your database. If you type a name you can have it look up the name and return the results.

Let me know what specific questions you have about getting your script to work and I'll be glad to help.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
designersxAuthor Commented:
sir this is not i want.

i am saying that i have a database, suppose there are 2 fields.
name    age

yogesh  23
deepak  27

on the front end,
deepak are shown, when i click on yogesh 23 is shown, when i click on deepak 27 is shown with ajax.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.