Hi all, I'm working on a simple site to help me and others determine which handheld/game/phone to buy.
Before it had a table like this: Phone,color y/n,wireless y/n, etc... Now it is many tables so that new fields can be added while the site is up without having to change the db structure. First table is called specs: Specs: ID, Name ID, Field ID, Value ID example: 1,1,1,1 would be a spec Names: ID, Name 1, Motorola T720 2, Nokia Ngage Fields: ID, Fieldname 1, Width 2, Height Values: ID, Value 1, 1" 2, 3" I'm trying to print the data in a table like this: The table heading Name, Field1, Field2.... where field1, field2 are filled in with the Field names from the db whick would look like: NAME, WIDTH, HEIGHT followed by the table contents Motorola, 1", 3" ... This style of storage was recommended to me because of its flexibility but has me lost for query :) Thanks, Steve __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
