First time here? First time here? Newsletter Signup Newsletter
Login | Register | 651326 Members and growing!
Search tutorials
Author: Mirza Hatipovic

The application

What do we need to run the poll?
- a mySQL database
- an Apache Web Server with PHP

Installation instructions can be found at www.webmonkey.com.

MySQL Tables

Ok, now we will create the necessary tables.Please note that the field names are written in bosnian language and changing the field names to something else would confuse PHP. So, type the following SQL into your shell prompt (or use phpMyAdmin):

create table anketa_pit(
	poll_id int not null auto_increment,
	pitanje text,
	primary key(poll_id)
	);

create table anketa_odg(
	poll_id int not null references anketa_pit,
	odg_id int not null auto_increment,
	odgovor text,
	hits int,
	primary key(odg_id)
	);

As you can see, only 2 tables are nedded. So, we’re finished with the database, let’s move on to other tasks.

» Level Advanced

Added: 2003-07-21
Rating: 6.75 Votes: 84
(10 being the highest)
» Author
Mirza Hatipovic is freelance developer based in Bosnia and Hercegovina. He uses Flash MX, PHP, XML amd Coldfusion to create dynamic web content.
» Download
Download the files used in this tutorial.
» Forums
More help? Search our boards for quick answers!

Comments

  • 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.