ratemy/hotornot.com question.

[[S]tampede]

i recently got an idea for a site that i'm sure would generate lots of hits and its a kinda "ratemy" or hotornot.com site where ppl rate things.

but i'ma noob when it comes to everything but html, and i'm pretty sure that inorder to to set it up theyre using databases/php and ****.

can somebody briefly explain to me how these sites are set up and managed so i can get to work and start learning how to do it and set my site up?

[96turnerri]

well in around about way

users register, upload a pic, which is put into a folder, and an entry added to MySQL for it, then another person comes to the site and views pics, and a random number is generated and that picture is displayed that corresponds to the number genreated, they then rate it via a form, what they rate is stored in MySQL after being averaged from all results in the same row as the picture, then another number is generated and the proccess continues, easy stuff ;)

[[S]tampede]

yeah lol sounds easy. yeah right. so uh what do i need to start understanding first, some mysql or what?

the form wouldnt be a big problem, because i've worked with them before, just gettin it to store the votse in the database and tally up the averages is what i dont understand

[96turnerri]

well yeah it is easy :p

ok start by learning some SQL (INSERT, UPDATE mostly), and working with PHP uploads (for the images)

[[S]tampede]

any idea where some good sql and php tutorials are for this kinda thing?

[96turnerri]

http://uk2.php.net/manual/en/features.file-upload.php

http://dev.mysql.com/doc/mysql/en/INSERT.html
http://dev.mysql.com/doc/mysql/en/UPDATE.html

should be more than enough

[silent11]

There are a few clones out there that have already been written - I'm sure some are even free.

Here is one written in perl by Randal L. Schwartz: http://www.stonehenge.com/merlyn/WebTechniques/col59wt.html