i have one parent table and one child table.
so in parent table only one records will stay for one bunch of records and remaing records will pushed into child table.so scenario may be like this in MSATER table for one record there may be 3 reords in child table
2-in MSATER table for one record there may be 5 reords in child table
3-in MSATER table for one record there may be 10 reords in child table and so on..
parent table Child table
id Student_name age phone id Student_rollno Student_name FatherNAme
1 manoj 23 42846209862 1 34 manoj Deepak
1 23 ramesh Kailash
1 45 raja tara
I want data in this format
id Student_name age phone FatherNAme1 FatherNAme2 FatherNAme3
1 manoj 23 42846209862 Deepak Kailash tara
But currently we have 3 records but if I have 10 records then also tha data comes in similar fashion means( FatherNAme1 coloumns repeat 10 time)
How can I do this.I need to store data in a single row.
View Complete Post