Hi, I am new to web development... mostly i learn my own..
I got to design a database structure so to store items similar to tags and posts in a blog. The design would be:
_____________
Tag Table
TAGID | TAGNAME
_____________
_____________
Post Table
POSTID | POSTNAME
_____________
_____________
Tag Post Relation Table
TAGID | POSTID
_____________
Now what i have read online over the time, this is the best way to store TAGS and relate it to the posts.. (please correct me if i am wrong) Now my doubt is how to retrieve all TAGNAME(s) associated to a POSTID.
Sorry for such a newb question but even i was unable to figure out what query do i search in google.
And please recommend me some good notes/tutorial on MySQL.