how to insert data in mysql db? 2 comments
i am working on a autoresponder and i want the question came from database as well as the answer..my question is how will i do that?pls soe one help me..thanks!
Autoresponder related posts:
2 Responses to 'how to insert data in mysql db?'
Subscribe to comments with RSS or TrackBack to 'how to insert data in mysql db?'.
-
Paul W
3 Mar 10 at 12:29 pm
-
If I understand your question, you want a question and answer to come from the database. So, you need to set up the database with the various fields, say: Question and Answer. You insert these with their proper keys in the usual way (create, insert, update, commit), and retrieve the one you want with a select.
Two ways:
use php to set up the form in which the questions/answers would be entered; these would show on the client-side machine, and get passed back to the server. The server side process would then open the database, do the necessary checks, write/insert the new record (or update an existing record), commit the changes to your database and close the database. Great for one Q&A at a time.
the other way is to use the native database language to load the Q&A’s in bulk, probably from a CSV file or some such. Similar to the other, but only one open and one close for the whole database.
Peter B
6 Mar 10 at 3:01 am
Use the INSERT statement in your sql statement. I have no idea what programming language you plan to use.