disdainedangel
New member
I need a little help with my PHP/MySQL query. I'm trying to query a table which has a row full of 'tags' that are seperated by commas. When the user uses the site search, the query will search the table row which is filled with the tags, search within the comma delimited tags and find and return all results which had the searched tag inside the aforementioned file's row. I was going to use a seperate database for the file tags but a very kind gentleman advised against ever using a JOIN so......
The results, if just using echo for all the rows are like this:
linkID = 23124532
linkTitle = thefilename
linkCategory = 23
linkSubCategory = 53
linkCreator = someguy
linkSubDate = 13/2/2000
linkTags = cow,pig,horse,car,tree,explosion,rage,drink,coffee,food,love,beer,etc
The results, if just using echo for all the rows are like this:
linkID = 23124532
linkTitle = thefilename
linkCategory = 23
linkSubCategory = 53
linkCreator = someguy
linkSubDate = 13/2/2000
linkTags = cow,pig,horse,car,tree,explosion,rage,drink,coffee,food,love,beer,etc