how can i store different master table record in other single table in php and mysql? e.g; i hv a member_master table and its field is member_name,member_id,city,area,so on. nd hv a other table is bill_setup nd its field are ten different heading and its charges e.g for security charges is 100 so on up to 10 field, nd hv created a form in which i can select month and there is a button,nd i have to store all information in a table which is named as allbktable nd its field is member_id, name,bill_amt,date,heading1,....heading10,charges1,charges2......charges10.thn how can i scan all table using while loop and store in ths table???