MySQL Help! I am trying to use tags on my web site. I am trying to allow users to search for tags. I want the users to do a search like "castle+moat-ducks" and return all pages that have the tags castle and moat but DO NOT have the tag duck. How can I do this? There is a single tag table, which contains 3 fields, tag_id, image_id and tag, which holds the actual text of the tag. Please help me set up the proper query! Note that I am using PHP.
Please help me create a MySQL database from a collection of images. There is of course [more inside]