I need a case statement in mysql to say basically: If $fromLvl = 0.0 and $toLvl = 12.12 then do this else do this. Im really not too sure of the syntax. Thanks in advanced.
SELECT itemregister.itemID) FROM itemregister CASE WHEN $fromLvl = '0.0' and $fromLvl = '12.12' THEN WHERE WHERE rdlvl >= $fromLvl and rdlvl <= toLvl ELSE --- SELECT EVERYTHING - Something like that. Regards, Eleno Davila Gorman Learning Center (909) 307-6312 ext 239 [Non-text portions of this message have been removed] Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
