mysql contact lookup
Posted: Tue Jul 19, 2005 10:23 am
hi there. i am woking on a school project and i am wanting is to make a members details lookup.
I have mad 3 forms so far
I am wanting three dropdown boxes the fist one will select either the members in the members table or the bands in the band table. depending on which one is selected in the second dropdown box i would want either the bands displayed or the members first name diaplayed. Then if the one of the bands is selected i would want the band members to be displayed in the third box, or if a member is selected then their details are diplayed below the boxes. etc
hope this is clear :s i kinda have a way of making thngs sound comlicated :s
Any help would be great
thanks again
Eric[/list]
I have mad 3 forms so far
- form to enter members details (entered into table members)
In it i have the colums, name, age, telephone number, street, village, town, postcode, email.
- form to enter the band members details (entered into table band)
In it i have the colums, band, name, age, telephone number, street, village, town, postcode, email.
I am wanting three dropdown boxes the fist one will select either the members in the members table or the bands in the band table. depending on which one is selected in the second dropdown box i would want either the bands displayed or the members first name diaplayed. Then if the one of the bands is selected i would want the band members to be displayed in the third box, or if a member is selected then their details are diplayed below the boxes. etc
hope this is clear :s i kinda have a way of making thngs sound comlicated :s
Any help would be great
thanks again
Eric[/list]