FN-FORUM: Puzzler - PHP/MySQL

date posted 17th January 2004 17:19

Here's one that's got me headscratching.

Suppose I have a list of possible image categories (front, left, right
etc.) in one table and I only want to add one of each images to an item
record.

I have another table that records which category each image is in (for a
given item).

How would you do it?

I can look up which categories have been used for an item and then select
possible categories that don't match, but that seems clunky?

anyone got a better logic?

cheers

Tony

--
listening to: "if you don't know me by now" by David Brent

http://www.xebit.net/