general php join question

[eluser]new_igniter[/eluser]
Hello,
I am wondering if someone can give me some pointers. I am working on a simple site that is unfortunately outside of CI, and is PHP.

I have 2 tables,

one with the main business name:

CREATE TABLE `twibsDB` (
`twibsID` int(11) NOT NULL auto_increment,
`twibName` varchar(255) NOT NULL,
`createTime` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`twibsID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2201 ;

the other with tags associated with that business:

CREATE TABLE `twibTags` (
`tagID` int(11) NOT NULL auto_increment,
`tagText` varchar(300) NOT NULL,
`twibsID` int(11) NOT NULL,
`createTime` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`tagID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5160 ;

The tables are associated though `twibsID`, the primary AI key in the first table and there could be 10 or 12 tags associated with each business.

How would I write the mysql query with a join statement so that I could get something back where I could loop through the businesses and if they had tags, loop through the array of tags? I have been doing a lot of experimenting, but nothing is working and I am just looking to learn here.


Thanks so much!!!!

[eluser]umefarooq[/eluser]
hi you can do one thing if you have array of tags just implode the whole array with like this

Code:

$tags = implode(',',$tagArray)

than use this query

Code:

select a.twibName from twibsDB as a inner join twibTags as b on a.twibsID = b.twibsID
where a.tagText in('$tags');

check it will work fine.