[question]Get info From multiple rows

Tozzie · 09-25-2007, 02:15 AM

Hey guys :)
i was wondering if i could get some help, im currently working on a tutorial script , and i want to display tutorial listing from multiple "sub-categories".
See whati ive got set up is sub categories under photoshop, So basically i want to display all the tutorials that make up the photoshop category.
like this:

Code:

"SELECT * FROM tutorials WHERE category = 'Drawing Effects Forum Signatures General Design Photo Effects Special Effects Text Tips &amp; Tricks Web Design"

But i know that wont work,
i've tried this too:

Code:

"SELECT * FROM tutorials WHERE category IN ('Drawing, Effects, Forum Signatures, General Design, Photo Effects, Special Effects, Text, Tips &amp; Tricks, Web Design)"

I would love to get any help :)

Thanks in advance! :)

-Tozzie