snowboardr
Programmer
I am developing a search page right now, I need help on doing a slightly complicated select...
Basicly I have 3 tables
forumpost, thetags, usertags
Ok basicly what I would like to do is search all forumposts, but attach "some" of the tags to that post, but the problem is that there could be many tags.... so I don't want to go overboard... I don't know how many tags would be an efficient number... so whatever you think would be decent for results.
The way my tags work is that if a user adds a tag it checks thetag database to make sure its not a duplicate, then adds a row to the usertags table joining thetags database and also usertags to the forumposts.
I am not sure how you would joing multiple columns like that or even what to search for to find out how to do it...
Thanks for the help.
Jason
Jason
[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]
Basicly I have 3 tables
forumpost, thetags, usertags
Code:
forumpost
pid | psubject | pbody
Code:
thetags
tid | ttag
Code:
usertags
uxtagid | uxforumpostidOk basicly what I would like to do is search all forumposts, but attach "some" of the tags to that post, but the problem is that there could be many tags.... so I don't want to go overboard... I don't know how many tags would be an efficient number... so whatever you think would be decent for results.
The way my tags work is that if a user adds a tag it checks thetag database to make sure its not a duplicate, then adds a row to the usertags table joining thetags database and also usertags to the forumposts.
I am not sure how you would joing multiple columns like that or even what to search for to find out how to do it...
Thanks for the help.
Jason
Jason
[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]