Page 1 of 1

Sample Forum mySQL Database

Posted: Thu Jul 24, 2003 10:01 pm
by dug1967
Is there such a thing?

With all the use of php and mySQL for forums (including this one) I would think somewhere there would be download-able mySQL databases. Something you could learn from or use as a starting point for you own.

Could anybody point me to such a thing? OR would you be willing to share yours?

I admit I am new mySQL and am not having much luck deciphering it so far. I sample to look at would be most benefical.

Thanks for your time.

...

Posted: Fri Jul 25, 2003 1:16 am
by kettle_drum
Just download any open source forum that uses mySQL and then look at it.

Another good way to learn is to download phpmyadmin and just have a play about, adding new tables and rows and then reviewing the sql code that it shows you.

If you want to make your own forum and want to know what to store in the database - then just think it over. Think about what details must be stored and then spilt it up into different tables and you have your database. Like you know you will need to store the messages - so make a table called messages which include everything that a message would include (the message, title, id number, thread id, posted by, time posted, if its a sticky etc)

If youve only just started learning sql then check out the mysql manual on their site, and then search good for sql tutorials and read away.

http://www.w3schools.com has a good tutorial on sql.

Posted: Fri Jul 25, 2003 1:49 pm
by pistolfire99
dug1967:- I have created a forum from scratch of my own. Its very simple, only 6 pages *.php pages with three tables in my MySQL database. Here is the link.
http://www.i2l2.com/kpsnatest/xxxforum.php

If you want something like this then its very simple. I am planning/designing to add more features. I am creating an Online Directory Management for my community and they need a simple message board, so I am working on the same.
Let me know your thoughts about my forum and if there are any improvements that I can make thanks.