[kev7607]

Hi,
Probably a simple question for you experts.
On my website I have a table of players with their teams, values, points etc.
Id like to make it so that the list can be sorted by value or alphabetically.
Can somebody give me some help or point me in the right direction.
Many Thanks
Kev

[ShocK]

Hi, I take it you mean auto sorted and not manual? If so then I reckon you'll need a database and a script and then someone much better qualified than me to follow up.

[bubt]

Basically there two ways to accomplish what you want.

1. If you don't want to use a database I would recommend using javascript to sort and order your table.
People who don't have javascript unabled will just see your table everyone else will be able to sort and order the table.

Example see this website:
http://yoast.com/articles/sortable-table/

2. More advanced would be to store your player information into a database
and use php queries to return your table and order it.
Which would require you to use $_GET variables to order and sort your query.

Here is a small Example:

// database connection script

$order = $_GET['order'];
$sort  =  $_GET['sort'];

// if the url looks like this page.php?order=teams
// php will order by teams
if (isset($order) && (!empty($order)) )
{
      $extend_query = 'ORDER BY ' . $order;
}

// get your players data from db
$sql = 'SELECT * FROM table ' . $extend_query;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)
{
    // echo table
}

Basically the idea behind it is to extend and change your database query to change the output to the page.

[kev7607]

Originally Posted by bubt

Basically there two ways to accomplish what you want.

1. If you don't want to use a database I would recommend using javascript to sort and order your table.
People who don't have javascript unabled will just see your table everyone else will be able to sort and order the table.

Example see this website:
http://yoast.com/articles/sortable-table/

2. More advanced would be to store your player information into a database
and use php queries to return your table and order it.
Which would require you to use $_GET variables to order and sort your query.

Here is a small Example:

// database connection script

$order = $_GET['order'];
$sort  =  $_GET['sort'];

// if the url looks like this page.php?order=teams
// php will order by teams
if (isset($order) && (!empty($order)) )
{
      $extend_query = 'ORDER BY ' . $order;
}

// get your players data from db
$sql = 'SELECT * FROM table ' . $extend_query;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)
{
    // echo table
}

Basically the idea behind it is to extend and change your database query to change the output to the page.

Thanks bubt, just what I was looking for - Kev