First time here? First time here? Newsletter Signup Newsletter
Search tutorials
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:

MySQL Database/Table Creation Script
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)

Note: You need not create a new database, you can use an existing one.

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.
MySQL Database Insert Script
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.');

Note: I suggest you insert just a few records right now, just in case you can't get the scripts working.
» Level Advanced

Added: 2001-02-19
Rating: 8.04 Votes: 48
(10 being the highest)
» 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.
» Forums
More help? Search our boards for quick answers!


  • There are no comments yet. Be the first to comment!

  • You must have javascript enabled in order to post comments.

Leave a Comment
  • Your email address will not be published. All fields are required.
Featured Flash FLA
» Author: Inocreato
» Title: RaiseTheBlocks
» Description: Raise all the blocks to win the game
Featured Sound Loops
Image for equalize

Audio Player

» Author: TomCat Carty
» Title: The Wood
» Description: Just a little game ending or it can maybe be looped. Recorders with music box and percussion to give the feel of well, I don't know, the woods? Free to use, just credit me. thank you
Latest Font
» Author: Fábio FAFERS
» Description: I created this font for free use. Everyone can apply it in personal or business texts. Its free, but I want to be communicated in case of business use. Donations are accepted to keep the project of free fonts alive! Thank you all
Featured Sound Fx
Image for equalize

Audio Player

» Author: Davisigner
» Description: Hmm... what to say about this one? It's reminiscent of the closing notes of the opening music from the Three Stooges done in a church organ style with a closing cymbal crash. I'll give this one away gratis, but feel free to check out my free loops and potential upcoming license-mandated ones over in the respective part of Flashkit.