Site: http://www.handheldspecs.com Benefit for helping: Better your PHP/MySQL Know what color/java/phone/game/handheld/mp3/radio/bluetooth to buy (yes Nokia-Ngage does all this) Link on front page of your choice MySQL people aren't necessarily PHP programmers. The site is in PHP so I picked here. If this project is not welcome here pls tell me where to post since it is php/mysql and in php and I apologize now to hope stop the abuse :) If you see the site you know it has sorry db design. My friend suggested this: use three tables. At first glance, it may seem more complicated, but will make your work much easier in the long run.
HandHeldNames ID (integer, automatically assigned) Name (String, unique) Fields ID (integer, automatically assigned) Name (String, unique) Type (if necessary. There are several ways of doing this) HandHeldSpecs Name (integer, joined to the ID of HandHeldNames) Field (integer, joined to the ID of Fields table) Value (String. There are several ways of doing this, actually) For instance, what you currently have on the handheldspecs.com site would have the following values HandHeldNames ID | Name 1 | Motorola T720 2 | Nokia 3 | Emerson Fields ID | Name 1 | Screen Width 2 | Screen Height 3 | Pixelsx 4 | Pixelsy 5 | Java Support 6 | Color 7 | Bandwidth 8 | image HandHeldSpecs Name | Field | Value 1 | 1 | 1 1 | 2 | 2 1 | 3 | 320 1 | 4 | 200 1 | 5 | yes (or 1 or however you want to represent booleans) 1 | 6 | yes 1 | 7 | 19 1 | 8 | (the image file name, for instance) ... I like this very much. It relates to the posts about generated select boxes. It would be real easy to add info to it and it is a fun newbie project for me to learn php/mysql as I can barely connect and make queries. thx. please lets be happy friends. --------------------------------- Do you Yahoo!? Free online calendar with sync to Outlook(TM).
