PHP array and Database schema ideas

[mobij]

Ok.

Lets say these are my tables in MySQL

Table1 = bowl type
Table2 = cereal type
Table3 = spoon type

I want to create something like this:

user select the bowl type a drop down menu display>
( i used select * from Table1 , then loops the array to create this drop down menu)

then

new drop down menu to select cereal type >

then

new drop down menu to select spoon type >

Not sure what to do after Table1. Some help please.
Edit/Delete Message

[acrabadabra]

Assuming the tables are not linked at all, you can repeat the same query as you used for Table1. Then after the user has selected from the 3 pulldowns he post the information by the form (you have created) and you can store it in your database (in a fourth table) by their IDs.

Fourth Table

user, relBowlID, reCerealID, reSpoonID

PS. Don't forget to click "Mark Thread Resolved" if this answers your question.

[bpat1434]

Run three queries, and store all the values into an array. Then loop through the array to populate the drop-down menus. You'd use an onchange="" event handler to submit the form on the change of each drop-down menu, and a final submit button to finalize some settings with the form.

~Brett

[mobij]

how can I run 3 queries on the same page? have php post self ?

i'm not sure how table linking are working. can you please provide some examples?

please go easy

thanks