here is my three table data
–
– Table structure for table carbon_topics
CREATE TABLE IF NOT EXISTS carbon_topics (
ID int(11) NOT NULL AUTO_INCREMENT,
Topic varchar(255) NOT NULL,
Tags text,
UserID int(10) unsigned NOT NULL DEFAULT ‘0’,
UserName varchar(50) NOT NULL,
LastName varchar(50) DEFAULT NULL,
PostTime int(10) unsigned NOT NULL,
LastTime int(10) unsigned NOT NULL,
IsGood tinyint(1) unsigned DEFAULT ‘0’,
IsTop tinyint(1) unsigned DEFAULT ‘0’,
IsLocked tinyint(1) unsigned DEFAULT ‘0’,
IsDel tinyint(1) unsigned DEFAULT ‘0’,
IsVote tinyint(1) unsigned DEFAULT ‘0’,
Views int(10) unsigned DEFAULT ‘0’,
Replies int(10) unsigned DEFAULT ‘0’,
Favorites int(10) unsigned DEFAULT ‘0’,
RatingSum int(10) unsigned NOT NULL DEFAULT ‘0’,
TotalRatings int(10) unsigned NOT NULL DEFAULT ‘0’,
LastViewedTime int(10) unsigned NOT NULL,
PostsTableName int(10) unsigned DEFAULT NULL,
ThreadStyle varchar(255) DEFAULT NULL,
Lists longtext,
ListsTime int(10) unsigned NOT NULL,
Log longtext,
PRIMARY KEY (ID),
KEY LastTime (LastTime,IsDel),
KEY UserTopics (UserName,IsDel,LastTime)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
–
– Table structure for table carbon_posttags
CREATE TABLE IF NOT EXISTS carbon_posttags (
TagID int(11) DEFAULT ‘0’,
TopicID int(11) DEFAULT ‘0’,
PostID int(11) DEFAULT ‘0’,
KEY TagsIndex (TagID,TopicID),
KEY TopicID (TopicID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
–
– Table structure for table carbon_tags
CREATE TABLE IF NOT EXISTS carbon_tags (
ID int(10) unsigned NOT NULL AUTO_INCREMENT,
Name varchar(255) NOT NULL,
Followers int(10) unsigned DEFAULT ‘0’,
Icon tinyint(1) unsigned DEFAULT ‘0’,
Description mediumtext,
IsEnabled tinyint(1) unsigned DEFAULT ‘1’,
TotalPosts int(10) unsigned DEFAULT ‘0’,
MostRecentPostTime int(10) unsigned NOT NULL,
DateCreated int(10) unsigned NOT NULL,
PRIMARY KEY (ID),
KEY TagName (Name) USING HASH,
KEY TotalPosts (IsEnabled,TotalPosts)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
===================================================
I want select topics from table carbon_topics AND only certain tag for example “tag1”
here is what I do
$sql = "SELECT carbon_topics.Topic, carbon_topics.ID, carbon_topics.Tags
FROM carbon_topics
WHERE carbon_topics.Tags = ‘tag1’ ";
i think i failed