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?

Posted on 2009-04-28
Medium Priority
Last Modified: 2012-05-06
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.
Question by:designersx

Accepted Solution

blacksix earned 500 total points
ID: 24250249
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.

Author Comment

ID: 24250465
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.


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month13 days, 8 hours left to enroll

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question