Jump to content


Photo

Catagories


  • Please log in to reply
2 replies to this topic

#1 Linux_BSD_Unix

Linux_BSD_Unix
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 03 October 2006 - 01:46 AM

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?

#2 Stinger

Stinger
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 03 October 2006 - 07:37 AM

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;

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”
[url=http://ipb1p3.ifastnet.com/][/url]

#3 Linux_BSD_Unix

Linux_BSD_Unix
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 03 October 2006 - 10:45 AM

Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users