php - Show data from database

I have table part like this

id_part process 
1         1
2         2
3         3
Copy code

Each process have table in database

proces 1
id_prs1 name     qty  id_part
1       blank     2     1
2       piercing  5     2
3       bending   6     3

proces 2
id_prs2 name   qty  id_part
1       stamp  2       2
2       pierc  4       3

proces 3
id_prs2 name   qty  id_part
1       cut     2       3
Copy code

i want show in form based on value process in table part, if they have 2 process then they show table process 1 and process 2 and if the number 3 they will show table process 1,2 and 3.

i already try this

SELECT part.process, process1.name, process1.qty,process2.name, process2.qty, process3.name, process3.qty FROM part inner JOIN process 1 on process1.id_part = part.id_part inner JOIN process 2 on process2.id_part = part.id_part inner JOIN process 3 on process3.id_part = part.id_part where part.id_part = '$part'
Copy code

but in form only show if the process in table part have value 3.

process value = 2

process value = 3

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.