Generate picture galleries from MySQL database.

Generate picture galleries from MySQL database. is project number 275135 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider ThetaPi
Budget:	$30-250
Created:	06/16/2008 at 7:58 EDT
Bidding Ends:	06/19/2008 at 7:58 EDT
Project Creator:	asiaboy   Buyer Rating: (3 reviews)
Description:	This project is for a gay adult site and you should be comfortable working with adult material! I need a PHP program that can select 12 pictures from a MySQL database that has information about more than 30000 pictures. Each picture in the database has a date, name, keyword(s), title and a rating. Please see the sample of the relevant database that is attached to this project. The program should be able to create a static PHP gallery with thumbnails of the pictures from a template (also attached). The pictures must be selected random, but within certain criteria based on keyword, rating, date and title. It should be possible to set these criteria when a gallery is generated. When generating a new gallery, the program should be able to track (from a separate database table) pictures that are used in galleries, so there will be no duplicates from one gallery to the next. The database also contains links to videos. These should be ignored by the program. Actual pictures and thumbnails are in a non public area of the server and the program should create symbolic links from the pictures and related thumbnails to the location of the gallery. Additional files submitted: photos.sql.zip sample_gallery.php
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	15
Average bid:	$ 184