How can I insert posted data into the database?

Help in making database table for poll system because i am bigner in database?

  • my database table is CREATE TABLE pollquestions (ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Question CHAR(255)); CREATE TABLE pollanswers (ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Question INT, Answer CHAR(255), Votes INT DEFAULT 0); my question is how can i insert following data in table in web server INSERT INTO pollquestions (Question) VALUES ('Favourite film?'); INSERT INTO pollanswers (Question, Answer) VALUES (1, 'Casablanca'); INSERT INTO pollanswers (Question, Answer) VALUES (1, 'Aliens'); INSERT INTO pollanswers (Question, Answer) VALUES (1, 'Indiana Jones'); INSERT INTO pollanswers (Question, Answer) VALUES (1, 'Pride & Prejudice'); INSERT INTO pollanswers (Question, Answer) VALUES (1, 'The Matrix'); INSERT INTO pollanswers (Question, Answer) VALUES (1, 'Kill Bill');

  • Answer:

    you will have to write a browser screen to do this, using PHP or similar scripting language. This will paint the screen as a form, accept input fields and insert into the database when the submit button is clicked.

JAMSHAID at Yahoo! Answers Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.