[RESOLVED] Table sorting

[neljan]

Hello :o

Quicker to show you...

http://www.clanrv.worldclanleague.com/index.php?site=timetrials_lc&sort=nickname&page=1

If you click on 'nickname' (or any other value) it doesn't sort straight away but instead appears to just set the sort type. Then when you click 'sort', it'll sort the table.

What I would like instead is for it to sort straight away when you click on nickname, and sort again the opposite direction when it's clicked again (the traditional way):

Example:

http://www.ajaxdaddy.com/demo-table-sort.html

(but thats Java)

I'm using this code:

php

$sort="LC";
if(isset($_GET['sort'])){
  if(($_GET['sort']=='nickname') || ($_GET['sort']=='clantag') || ($_GET['sort']=='LC')) $sort=$_GET['sort'];
}

$type="ASC";
if(isset($_GET['type'])){
    if(($_GET['type']=='ASC') || ($_GET['type']=='DESC')) $type=$_GET['type'];
}

if($pages>1) $page_link = makepagelink("index.php?site=timetrials_lc&sort=$sort&type=$type", $page, $pages);
    else $page_link='';

if($page == "1") {
    $ergebnis = safe_query("SELECT * FROM ".PREFIX."timetrials ORDER BY ".$sort." ".$type." LIMIT 0,".$maxusers);
    if($type=="DESC") $n=$gesamt;
    else $n=1;
}
else {
    $start=$page*$maxusers-$maxusers;
    $ergebnis = safe_query("SELECT * FROM ".PREFIX."timetrials ORDER BY ".$sort." ".$type." LIMIT ".$start.",".$maxusers);
    if($type=="DESC") $n = ($gesamt)-$page*$maxusers+$maxusers;
    else $n = ($gesamt+1)-$page*$maxusers+$maxusers;
}

$jumpmenu='<select name="select_member_type" onchange="MM_jumpMenu(\'parent\',this,0)">
               <option value="index.php?site=timetrials_lc">- Show all users -</option>
               <option value="index.php?site=timetrials_lc_rv">- Show only Rv members -</option>
               </select> 
               <input type="button" name="Button1" value="go" onclick="MM_jumpMenuGo(\'select_member_type\',\'parent\',0)" class="button" onfocus="blur()" />';

$anz=mysql_num_rows($ergebnis);

if($anz) {

if($type=="ASC")
$sorter = '<a href="index.php?site=timetrials_lc&amp;page='.$page.'&amp;sort='.$sort.'&amp;type=DESC"><img src="images/icons/sort_asc.gif" width="49" height="18" border="0" style="vertical-align:middle;" alt="Sort DESC" /></a>';
else
$sorter = '<a href="index.php?site=timetrials_lc&amp;page='.$page.'&amp;sort='.$sort.'&amp;type=ASC"><img src="images/icons/sort_desc.gif" width="49" height="18" border="0" style="vertical-align:middle;" alt="Sort ASC" /></a>';

html

<td class="timetrials-table-title" width="10%" style="color:#dbdbdb;"><a href="index.php?site=timetrials_lc&amp;sort=LC&amp;page=$page">#</a></td>
    <td class="timetrials-table-title" width="40%" style="color:#dbdbdb;"><a href="index.php?site=timetrials_lc&amp;sort=nickname&amp;page=$page">Nickname</a></td>
    <td class="timetrials-table-title" width="20%" style="color:#dbdbdb;"><a href="index.php?site=timetrials_lc&amp;sort=clantag&amp;page=$page">Clan</a></td>
    <td class="timetrials-table-title" width="30%" style="color:#dbdbdb;"><a href="index.php?site=timetrials_lc&amp;sort=LC&amp;page=$page">Time</a></td>

Thanks in advance.

[dagon]

well if you like the way that ajax script does it install it rather than using php to do it.

[neljan]

No I'd rather not use Java unless it's absolutely necessary, but thanks.

[dagon]

java script not java.

if you run the query on every load based on the url input it shouldn't be a problem.

[neljan]

Ok I'm looking at this:

http://tablesorter.com/docs/

But I'm unsure whether pagination will be maintained or whether it will only sort whats viewable on the current page. Guess I'll give it a try.

[dagon]

well that's javascript which you said you did not want 😕

[neljan]

Are you trying to help me? lol.

I know it's Javascript, Java, jscript, whatever 🙂

I tried it and it didn't work out for me so I'm looking to modify my existing code as originally planned.

[dagon]

neljan;10963078 wrote:

Are you trying to help me? lol.

well yes, but you keep changing your mind as to what you want so its not easy.

neljan;10963078 wrote:

I know it's Javascript, Java, jscript, whatever 🙂

well you dont seem to understand that those three are completely different

neljan;10963078 wrote:

I tried it and it didn't work out for me so I'm looking to modify my existing code as originally planned.

not sure what it your now referring to nor what help if any you now require.