Create x amount of checkboxes based on data in table

[gunnerone]

Hi,

Firstly, i have 2 tables that i need to populate. 'recipe' and 'recipeequipment'. I need to get a list of equipment from the 'equipment' table and their ids and display this to the user so they can choose what equipment they like(possibly more than 1).

My question is how do i create x amount of checkboxes with the equipment from the table. alongside this i will need a textbox so that the user can input how many of each equipment they want.

This will ofcourse need to be put into the database so will need unique ids in the form so i can get the values required.

Does anyone have any suggestions of how to accomplish this?

Thanks.

[Rabbit]

I assume you'll do it in a loop and use the unique id as part of the form control's name.

[Artnessde]

1) make sure your recipeequipment table has an auto increment primary key. By this you are having a unique key / id for every record automaticly.

2) SELECT all records from recipeequipment` where the recipe id is the one you need into one array.

3) use sizeof($arrayname) or count($arrayname) on the resultset to get the amount.

This way you have all the data you need alongside with the number of records and their respective unique ids (inside every record in the array)

Step 3 could be left off if you want to display the recipeequipment line by line .. you would just use some foreach() loop iterating over the array you got in 2)

2)