Jump to content

Archived

This topic is now archived and is closed to further replies.

Skitter

Desperate Website Help Needed!

Recommended Posts

im making a website for a college project that, for the most part, is going to be extremely complex, the idea of it is:


a list of people, the top of the list is the person who has paid the most, the spots look like this:

etc
55p
50p
45p
40p
35p
30p
25p
20p
15p
10p
5p

all the way to £10

every month the list starts blank apart from the highest bidder, who stays at the top until someone removes them, then, for example, someone pays 5p, and their name is immediately in the 5p position, if someone else was in the 5p position, then the person must bid 6,7,8,or 9p to knock them off the bottom of the list and take their place, if someone at a higher position does this, then everyone below that person moves down a place, and whoever is at the bottom gets knocked off, and emailed immediately that they have been knocked off the bottom of the list

how would this be coded into a website? if at all?

and if someone can run up some code for me if it is possible, they will get FULL credit for it on my website.

Share this post


Link to post
Share on other sites
You need to make a table with 3 columns- id(number), Name, Pounds paid (numbers only here).
Then, When you want to do that list use this statement (lets say you want to show the 50 people who paid most):
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] paid, name [color=green]FROM[/color] [color=orange]`people`[/color] LIMIT 50 [color=green]ORDER BY[/color] paid [!--sql2--][/div][!--sql3--]
And the rest is Normal PHP/HTML/CSS programing.

Orio.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.