* Seamus R Abshere
> i am developing a photo gallery with php4/mysql4.0 that uses
> faceted classification.
>
> -my tables:
> photos(photoid)
> metadata(photoid,facetid)
>
> -to select all of the photoid's that are associated with either
> facetid 1 or 2:
> SELECT DISTINCT photos.*
> FROM pho
dear fellow MySQL users,
i am developing a photo gallery with php4/mysql4.0 that uses faceted classification.
-my tables:
photos(photoid)
metadata(photoid,facetid)
-to select all of the photoid's that are associated with either facetid 1 or 2:
SELECT DISTINCT photos.*
FROM photos,metadata
WHERE
