Page 1 of 1

mysql contact lookup

Posted: Tue Jul 19, 2005 10:23 am
by ericburnard
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
  • 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]

Posted: Tue Jul 19, 2005 6:17 pm
by Burrito
the order of the way you're doing things sounds a bit funky.

you should order it so they select either band or members in the FIRST drop down, then the second will provide you with more information. Easiest way to do this is create an onChange event that submits the form to itself when the select box is changed. Then you can pull more info from the db based on what is selected and populate the subsequent dropdowns accordingly.