db design for production selection process
Posted by: Chris Bassett
Date: October 08, 2012 09:24AM

Need some advice here...

Trying to create a production selection system using PHP and MySQL (for the web, of course) where a person can specify what type of equipment they have (in this case, farming planter equipment) and our "selection wizard" can come up with a product that suits their needs based on the criteria they have specified.

I'm thinking this sort of needs to be a pivot table of some kind, where the wizard will "drill down" to one solution using the criteria.

Right now, I was thinking a series of fields (one field for each possible condition) in a table, and then use a query that finds a row in the table that maches the most number of fields in the query.

Any suggestions on how to do something like this? Examples??

Options: ReplyQuote


Subject
Written By
Posted
db design for production selection process
October 08, 2012 09:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.