--- "K.LaVallee" <[EMAIL PROTECTED]> wrote: > Then to select all items in category 1 and subcategory 23, your query > would > be : > (assuming $cat and $sub have been extracted from $_GET) > " > SELECT * FROM categorized_items, products > WHERE categorized_items.cat_id=$cat > AND categorized_items.subcat_id=$sub > AND products.id=categorized_items.item_id > "
AAAHHHHHH!!! That would probably do the trick. Thanks for the suggestion. I'll give that a shot tonight. Cheers, -Bob __________________________________________________ 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/