Auto populating form fields
Ok, i'm pulling in course data from mysql using php - there are many fields in the database. in the form, i allow a user to select a course from a drop down menu that is filled with the $course_title variable from the database.
My question is, when a user selects a course, i would like the other fields (such as department, section number, price and so forth) to be automatically filled out based on the values in the database that belong to the selected record, and i'm wondering if anyone can help me find a solution to this?
i've been told ajax can accomplish this.
thank you.