Jump to content


Photo

Desperate Website Help Needed!


  • Please log in to reply
1 reply to this topic

#1 Skitter

Skitter
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 22 April 2006 - 05:39 PM

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.

#2 Orio

Orio
  • Staff Alumni
  • Advanced Member
  • 2,491 posts

Posted 22 April 2006 - 06:48 PM

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 FROM `people` LIMIT 50 ORDER BY paid [!--sql2--][/div][!--sql3--]
And the rest is Normal PHP/HTML/CSS programing.

Orio.
Think you're smarty?

(Gone until 20 to November)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users