PHP/MySQL beginner group project

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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).

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux