DeveloperSide.NET Forums
July 14, 2020, 09:47:11 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
   Home   Help Search Login Register  
Pages: [1]
Author Topic: filtering products from a table (mysql)  (Read 3980 times)
0 Members and 1 Guest are viewing this topic.
Posts: 3

View Profile
« on: July 10, 2006, 03:40:24 PM »

Ok this is the deal, I am creating a table of products using mysql, the products have the fields prod_id, prod_desc, weight,  and price.

In addition to this the table also has fields for each of the 50 states in the US e.g (al, ak, ar, az........wy).

In the column for each state is a boolean value either 1 or 0.   1 indicates that product is available for sale in the state and 0 not available.

Problem: I am trying to create a filter for the products and display them on a php page according to state. i.e when u select al(alabama) on a drop down menu you will see only the products with a boolean value of 1 that are available in  alabama.

any suggestions on how i should setup my tables?
Pages: [1]
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!