I need to save data from a while loop and data from select option, Now I encountered that using my query I only save is the last part of my while loop and also the data that I choose in select option did not save.

Now my problem is how can I save in my database the data that display in a form as same as what it display.Honestly, it's my first time to encounter this kind of saving and i have no idea how possible it is.

I just want to happen is all data in while loop will save all in the database.

Thank you

Copy and paste these lines into the beginning of your PHP script:

<?php
$value = 'fred';
echo __LINE__ .' : $value= ' .$value; die;

Output: 3 : fred

Once that is working then:1. remove the lines2. find the $data that you are trying to save3. echo the LINE and the $data 4. echo your $sql statement5. echo the mysql result6. continue stepping through the scr[pt7. ...8. ...

Once that is working then:1. remove the lines2. find the $data that you are trying to save3. echo the LINE and the $data 4. echo your $sql statement5. echo the mysql result6. continue stepping through the scr[pt7. ...8. ...