Hi there! We're setting up a very-soon-huge online DB about photographs. The user will be able to search a photograph and then download it.
We'd like to let the user feel comfortable while searching his image and the search criteria will be up to 7 keywords, dimensions, author, price, b/w vs. colors and a short description
Now, at last, the question is: which table best fits for our pourposes? We thought these fields: ID, title, b/w, width, height, author, description, price, 1st keywords, 2nd keyword, 3rd keyword etc. etc., 7th keyword.
We better to search over 7 distinct keywords or unify them in a text field?
We're running MySQL/PHP4.
Thanx since now, hoping to be clear.
Bye all!
We'd like to let the user feel comfortable while searching his image and the search criteria will be up to 7 keywords, dimensions, author, price, b/w vs. colors and a short description
Now, at last, the question is: which table best fits for our pourposes? We thought these fields: ID, title, b/w, width, height, author, description, price, 1st keywords, 2nd keyword, 3rd keyword etc. etc., 7th keyword.
We better to search over 7 distinct keywords or unify them in a text field?
We're running MySQL/PHP4.
Thanx since now, hoping to be clear.
Bye all!