Selecting rows from MySQL

xgrm

New Member
I'm trying to create a web index. Every advertiser in my database will be able to appear on a few categories, so I've added a \[code\]categorys\[/code\] column, and in that column I'll store the categories separated by "," so it will look like:\[code\]1,3,5\[/code\]The problem is that I have no idea how I'm supposed to select all of the advertisers in a certain category, like: \[code\]mysql_query("SELECT * FROM advertisers WHERE category = ??");\[/code\]
 
Back
Top