Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Peeyotch
-
help categorizing and counting values
I will definitely try that structure. Right now I have made the current structure work with some pretty kludgy PHP, but I'd love to be able to eliminate a lot of it and let mysql do the work. Thanks! -
help categorizing and counting values
Well each row in that table represents a survey filled out. It has a fields for a uid, store number, date, and 20 fields for item numbers. Depending on how many item numbers were submitted, thats how many item fields have item numbers in them. If there is a better way to do this, I'm all... -
help categorizing and counting values
I'm tearing my hair out trying to work out this problem. A row in the main table consists of about 20 fields which, when filled out, will either contain a item number or NULL. Another table has a list of the possible item numbers and correspinding category ID's. The information I need out of...
