[HELP] How do I make a 1-100 list for a Game. [PLASE READ]

[JakeJumpsHigh]

How do I make a thing like this http://imobcodes.com/ so that people enter there user name and friend code and it puts them in a 1-100 line.. and when they do it the get put at #1 and go down as others post theres..

and i wanna make it so they can only post each hour..

also I wanna be able to change peoples name colors.. like if there a donor and such..

PLEASE HELP!! I think this is PHP with MySql If i dont have to use my MySql them please tell me how I can I have 0 knowledge of both of them..

So please check out these sites.. I wanna be able to do what there doing here is a couple more..

http://girlwarcodes.com

PLEASE HELP ME

[Old Pedant]

If you really have zero knowledge of both PHP and MySQL then you have two choices:

(1) Get ready to spend at least a couple of weeks (depends on how fast you are at leaning computer languages, etc. 2 weeks? 4 weeks? 12 weeks??) learning the basics of both PHP and MySQL. [But first check if the ISP you are using even supports PHP! If you are using a Windows-based host, for example, you may need to use ASP or ASP.NET instead.]

(2) Pay somebody to write this for you.

There's a separate forum on this site for hiring people to do little jobs like this.

[JakeJumpsHigh]

Originally Posted by Old Pedant

If you really have zero knowledge of both PHP and MySQL then you have two choices:

(1) Get ready to spend at least a couple of weeks (depends on how fast you are at leaning computer languages, etc. 2 weeks? 4 weeks? 12 weeks??) learning the basics of both PHP and MySQL. [But first check if the ISP you are using even supports PHP! If you are using a Windows-based host, for example, you may need to use ASP or ASP.NET instead.]

(2) Pay somebody to write this for you.

There's a separate forum on this site for hiring people to do little jobs like this.

Shouldint this be farly easy i mean all it is doing is putting things in a 1-100 line and droping them down as more people put there info (USername) in..?

I mean could you give me a simple one? Im usign 1and1 windows host...

[Old Pedant]

Sure, the SQL code is simple.

But now you have to learn how to use PHP to display what's in the DB table.

And you asked for lots of other extras, like coloring and donors and and and...

I am *NOT* a PHP programmer. But I consider myself expert in JSP and ASP and moderately advanced in MySQL, so I think I could do this in a day or two. Would probably take an experienced PHP person somewhat less than a day.

The SQL involved is pretty trivial:

To add a new person:
     INSERT INTO friends ( whenadded, friendcode, userid, donationamount )
     VALUES( Now(), $friendcode, $userid, $donationamount )

To get the last 100:
     SELECT * FROM friends ORDER BY whenadded DESC LIMIT 100

But after that...depends on how fancy you want it to be.

[JakeJumpsHigh]

Originally Posted by Old Pedant

Sure, the SQL code is simple.

But now you have to learn how to use PHP to display what's in the DB table.

And you asked for lots of other extras, like coloring and donors and and and...

I am *NOT* a PHP programmer. But I consider myself expert in JSP and ASP and moderately advanced in MySQL, so I think I could do this in a day or two. Would probably take an experienced PHP person somewhat less than a day.

The SQL involved is pretty trivial:

To add a new person:
     INSERT INTO friends ( whenadded, friendcode, userid, donationamount )
     VALUES( Now(), $friendcode, $userid, $donationamount )

To get the last 100:
     SELECT * FROM friends ORDER BY whenadded DESC LIMIT 100

But after that...depends on how fancy you want it to be.

Ok well I beleive you are smart enough to help me if you could?
I dont care how fancy it is I can code HTML... This is my site.. http://thatrandompodcast.com

So I can code the looks I just want to be able to put in a code and it adds it to the top of the list.. so it could like like this..

Girl Wars Code List ( Latest 500 )
(Add codes in red - They help keep the site up and usually are the best girl wars codes!)
# 166-123-560
# 156-792-587
# 141-447-342
# 173-592-127
# 115-449-854
# ect....

It can just be plain Ill center it and put design around it later..

Also I just want it to be like there friend code and thats all.. I want them to be able to put there code into a bar press done or enter then it puts there code in the list.

[Old Pedant]

Sorry, but not going to tackle PHP. I don't even have a PHP server to test with.

Maybe somebody else will read this.