setting up a forum
How would you setup the database in mySQL for a forum?
I havent really thought about the tables yet, but so far i just created this very quickly
and a few other tables called management, replies and topics.
$query="CREATE TABLE IF NOT EXISTS $users (
id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
username VARCHAR(10) DEFAULT 'anonymous' NOT NULL,
userpass VARCHAR(10) DEFAULT 'anonymous' NOT NULL,
secret_question VARCHAR(10) DEFAULT 'anonymous' NOT NULL,
secret_answer VARCHAR(10) DEFAULT 'anonymous' NOT NULL,
PRIMARY KEY (id)
How would you setup a forum like this?
As im in need of idea's
You could always look at an existing script to see how they have done it, or if you have a more specific question we may be able to give you more advice
Just look at the scripts of phpBB
Or, just use that forum altogether, unless you are doing this just to practice your php and MySQL skills.
Thats what i'm doing but at least i can see how to get started