Rookie needs help
Posted 04 October 2006 - 06:51 PM
I am building a website and I am stuck .
I have a form on one of my pages that has 5 fields(M,Tu,W,Th and F).Each field contains a question .Members have to answer each question in any particular order and one at a time.When they for instance answer question M and click on submit the answer goes into a table in my database.I use Mysql.Now the table has 6 columns :loginid,M,Tu,W,Th and F.
What I need is a code that inserts the data into the table one at a time and I want to have only one row,something like this:
loginid/answer to M/answer to Tu/answer to W/answer to Th/answer to F,
so everything is nice and neat.
And one more thing,I want to prevent them from sending in an answer to the same question twice.
Please help me out , I have been trying for about a month now with no success.
Thank you very much in advance for your time.
Posted 04 October 2006 - 07:48 PM
Posted 04 October 2006 - 08:03 PM
Posted 04 October 2006 - 10:21 PM
Posted 05 October 2006 - 04:55 AM
Posted 05 October 2006 - 06:54 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users