Camera Storage Media Database

To build a simple mysql database and php access page of Digital Cameras, Camcorders and Camera Phones, together with the storage media that they accept. The query page should allow the user to progressively select either Camcorder/Digital SLR/Point & Shoot/Mobile, followed by the Brand Name (Canon, Nikon, Sony, Nokia etc.), followed by the model name (5D, N90, D900), and finally deliver the type of compatible storage media (SD, SDHC, Compact Flash, XD, Memory Stick, etc.). As well as the storage media type, the fields for the database should also include: Device Type, Brand, Model Number Alternative Model Number (e.g Canon? EOS Digital Rebel XSi is also known as EOS 450D and EOS Kiss X2), Image Filename (for .jpeg of camera model), Number of megapixels (to 1 decimal place). Please note that a camera may have many media types, therefore a separate table of media types would be acceptable. A trusted source of data can be found at? [login to view URL] The coder will deliver an sql dump of the database, together with the .php code for the access page, and complete database entries for each camera of the brands listed on the above. The camera images can be ripped from the flickr site. Javascript or Ajax is also allowed for the query page - cool ajax type features may earn a bonus, as well as accuracy and integrity of the data - significant data inaccuracies will result in withholding payment until they are addressed (coder will not be penalised for inaccuracies with the Flickr data).