Linux_BSD_Unix Posted October 3, 2006 Share Posted October 3, 2006 Okay, I got my problem fixed i think with that tutorial I was doing. But now I need help. Could someone tell me how I would go about adding catagories to the forum so it will have catagories? This is a major feature I need that and registration, but I am in more need of it to have catagories. Could someone guide me? Quote Link to comment Share on other sites More sharing options...
Stinger Posted October 3, 2006 Share Posted October 3, 2006 [code]CREATE TABLE categories ( id smallint(5) NOT NULL default '0', position tinyint(3) default NULL, state varchar(10) default NULL, name varchar(128) NOT NULL default '', description text, PRIMARY KEY (id), KEY id (id)) TYPE=MyISAM;[/code]Add a “category” column, to your forum table, and then assign which forums are in which categories.Then use the appropriate mysql_query to grab the categories and forums in the right order.Ie. “ORDER BY c.position, f.position” Quote Link to comment Share on other sites More sharing options...
Linux_BSD_Unix Posted October 3, 2006 Author Share Posted October 3, 2006 Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.