Welcome Guest, Not a member yet? Register   Sign In
Advice? How to Tag?
#1

[eluser]georgerobbo[/eluser]
I am looking to add tags to my posts. I know you should have a different table for tags and posts. However I am unsure how to link the two?

My database structure is as follows.

Code:
--
-- Table structure for table `post`
--

CREATE TABLE IF NOT EXISTS `post` (
  `ID` int(11) NOT NULL auto_increment,
  `title` varchar(25) NOT NULL,
  `permalink` varchar(50) NOT NULL,
  `author` varchar(25) NOT NULL,
  `username` varchar(25) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `filename` varchar(25) NOT NULL,
  `description` varchar(200) NOT NULL,
  `category` varchar(25) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;


Messages In This Thread
Advice? How to Tag? - by El Forum - 10-19-2009, 10:09 AM
Advice? How to Tag? - by El Forum - 10-19-2009, 11:22 AM
Advice? How to Tag? - by El Forum - 10-19-2009, 12:35 PM
Advice? How to Tag? - by El Forum - 10-19-2009, 12:36 PM
Advice? How to Tag? - by El Forum - 10-19-2009, 12:57 PM
Advice? How to Tag? - by El Forum - 10-19-2009, 01:04 PM
Advice? How to Tag? - by El Forum - 10-19-2009, 01:08 PM



Theme © iAndrew 2016 - Forum software by © MyBB