--- Bob Sawyer <[EMAIL PROTECTED]> wrote: > first pull all the products whose SUBCAT field contained \n's (since > that's the delimiter), use PHP to create an array of the field, and > match the link subcat using in_array() ... unless anyone here can > think of anything better?
Well, again, if anyone can think of anything better, I'm all ears, but for now, it seems that simply using "... LIKE '%$sub%' ..." works OK. My main concern about "LIKE" is that if the linked subcat is "1" and the SUBCAT field contains '13,21' it'll pick that item up as well. -B __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Community email addresses: Post message: php-list@yahoogroups.com 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/