TalkPHP - View Single Post

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

09-25-2007, 02:15 AM	#1 (permalink)
Tozzie The Wanderer Join Date: Sep 2007 Posts: 8 Thanks: 0	[question]Get info From multiple rows 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 & 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 & Tricks, Web Design)" I would love to get any help :) Thanks in advance! :) -Tozzie