mysql contact lookup

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
ericburnard
Forum Contributor
Posts: 104
Joined: Wed Jun 15, 2005 5:11 pm
Location: Chesterfield, UK

mysql contact lookup

Post 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]
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post 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.
Post Reply