Webmaster forum - Can anyone answer this one?

Author

Can anyone answer this one?

instant karma

2005-05-20, 7:39 pm

I currently have a webpage (
http://www.tourney.com/tournament-poker-rankings.html ) that is just
html. As you can see, it's a huge list of information that includes
names, numbers, $$$ amounts, etc. I'd like to have this info able to be
sorted by clicking on a column kind of like this page:
http://www.cardplayer.com/player_of...der_by=amoun...
..

The CardPlayer page is in php. It seems like this is the best way to go
rather than creating multiple html pages that sort the data a different
way. Currently the raw data is just in an Excel spreadsheet.

How do I go about creating these PHP pages? I'm a total PHP newb. I
think I have to use some type of database for the PHP to pull the data
from too. Is this SQL? Anyways, I'd appreciate any help I can get, or
just a point in the right direction regarding resources. Thanks.

Charles Sweeney

2005-05-20, 7:39 pm

instant karma wrote

> I currently have a webpage (
> http://www.tourney.com/tournament-poker-rankings.html ) that is just
> html. As you can see, it's a huge list of information that includes
> names, numbers, $$$ amounts, etc. I'd like to have this info able to
be
> sorted by clicking on a column kind of like this page:
> http://www.cardplayer.com/player_of_the_year/index.php?
order_by=amoun...
> .
>
> The CardPlayer page is in php. It seems like this is the best way to
go
> rather than creating multiple html pages that sort the data a
different
> way. Currently the raw data is just in an Excel spreadsheet.
>
> How do I go about creating these PHP pages? I'm a total PHP newb. I
> think I have to use some type of database for the PHP to pull the data
> from too. Is this SQL? Anyways, I'd appreciate any help I can get, or
> just a point in the right direction regarding resources. Thanks.

Yes you would be right. You need a database. Do you want to learn
yourself, or pay someone?

--
Charles Sweeney
http://CharlesSweeney.com

instant karma

2005-05-20, 7:39 pm

I'd like to learn any info you may have to offer. There are three of
us working on this site with strong learning curves and lots of free
time. Thanks for the reply

Charles Sweeney

2005-05-20, 7:39 pm

instant karma wrote

> I'd like to learn any info you may have to offer. There are three of
> us working on this site with strong learning curves and lots of free
> time. Thanks for the reply

I would recommend PHP and mySQL. They work well, are free, and there's
lots of resources online for them. Most hosts these days offer them with
their hosting.

Difficult to say where to start. You will need to do a bit of work,
researching and learning. Probably best to search for a tutorial, then
take it from there.

--
Charles Sweeney
http://CharlesSweeney.com

instant karma

2005-05-20, 7:39 pm

We have phpnuke in our hosting - is that what we need to "master" to do
what we want to do?

Charles Sweeney

2005-05-20, 7:39 pm

instant karma wrote

> We have phpnuke in our hosting - is that what we need to "master" to
do
> what we want to do?

No. That's something that's written in PHP. You need to learn how to
write your own scripts/pages with PHP. You need to learn how to make
your scripts/pages connect to the database to insert data, or select
data.

If you have phpnuke, then you will have PHP and probably mysql available
to you.

Put these lines in a file, save it as hello.php then upload it to your
webspace. That's your first PHP script!

<?php

$message = "Hello World!";

print $message;

?>

Try doing a search for a tutorial to learn more.

--
Charles Sweeney
http://CharlesSweeney.com

instant karma

2005-05-20, 7:39 pm

I'll go in that direction, thanks all your help

Charles Sweeney

2005-05-21, 7:20 am

instant karma wrote

> I'll go in that direction, thanks all your help

Good luck.

--
Charles Sweeney
http://CharlesSweeney.com