Author: James Greenhalgh | Website: http://www.odslinux.com

Database Setup

The first thing you need to do is create the database structure. This can be accomplished using a GUI like phpMyAdmin, WebMin or from the shell account as follows:

CREATE DATABASE mydatabase;
USE mydatabase;
CREATE TABLE keyword_data (
    id int(11) DEFAULT '0' NOT NULL auto_increment,
    keywords varchar(120),
    question varchar(240),
    answer text,
    PRIMARY KEY (id)
);

Now we want to insert some test data, it will come in handy later while testing the Flash. I've provided for a few possibilities with the data below.

INSERT INTO keyword_data (keywords, question, answer) VALUES 
('contact reach phone address','How may we contact you?','Smoke signals are the best way to get a hold of us.');
INSERT INTO keyword_data (keywords, question, answer) VALUES 
('music mp3','Can I download your mp3s?','Yes, while you will have to sacrifice your first born child though.');
INSERT INTO keyword_data (keywords, question, answer) VALUES 
('phone toll free number','Do you have a toll free number?','Yes.');

» Level Advanced

Added: 2001-02-19 Rating: 8 Votes: 47 1 2 3 4 5 6 7 8 9 10 (10 being the highest) Thank you for voting! We have encountered an error. Please try again later. You've already voted.

» Author

I work for a Canadian software company as a logisitics director. We provide custom configured Linux distributions. In my spare time I sleep.

» Download

Download the files used in this tutorial.

Download (103 kb)

» Forums

More help? Search our boards for quick answers!