SORT - ORDER BY , more than one ?

[fla5h]

Is it possible in a query to sort by more than one value ?

I wanted to edit the sort by order options in the forumdisplay

so that when I sort by user name it will sort by username but also then sort them into the date of last post.

Is this possible ?

:rambo:

[Xenon]

ORDER BY username, dateline DESC

the priority is from left to right

[fla5h]

nice one Xenon, can you possibly help me further I am have problems doing what I want.

I wanted to make a link on the forum threads ( in the forumdisplay ) so that users can click on them and sort them in set order.

Ie a link next to the thread starters name that when pressed sorts the posts in that thread but also sorts them in the order of lastpost.

So the link I have tried is

/forumdisplay.php?s=&forumid=$forumid&sortfield=pos tusername,%20lastpost&sortorder=asc

It dont work, so I tried this

/forumdisplay.php?s=&forumid=$forumid&sortfield=tes t&sortorder=asc

then in forumdisplay found

PHP Code:

switch ($sortfield) {
  case 'title':
  case 'lastpost':
  case 'replycount':
  case 'views':
  case 'postusername':
  case 'voteavg': 


And added

PHP Code:

case 'test': 


after it, and found

PHP Code:

if ($sortfield=="voteavg" and !$foruminfo[allowratings]) {
  $sortfield="lastpost";
} 


and added after it

PHP Code:

if ($sortfield=="test"){
    $sortfield="postusername, lastpost";
    } 


I get the error

Parse error: parse error, unexpected ',', expecting ']' in C:\Network\Apache2\htdocs\request\forumdisplay.php (702) : eval()'d code on line 1

It dont seem to work even with the error there ?

Can you point me in the direction as to what I need to change ?

Thanks

[Xenon]

put

PHP Code:

if ($sortfield=="test"){
    $sortfield="postusername, lastpost";
    } 


after that:

PHP Code:

$sort = array();
$sort[$sortfield]='selected'; 


i think you've had it before an that made the problem..

[mr e]

why dont you try forumdisplay.php?sortfield=username,lastpost&order =asc

then change in the query

PHP Code:

$DB_site->query("SELECT blank FROM blank ORDER by $sortfield $order") 


that should work i think

[Xenon]

@mr_e: it wouldn work because of this switch case:

PHP Code:

switch ($sortfield) { 


[mr e]

but then couldn't he eliminate the switch all i thought the switch did was switch it between different querys, so it'd perform one query instead of another...that's what i thought anyway

[fla5h]

thanks once again it works fine, one problem I'm getting the following error at the top

Parse error: parse error, unexpected ',', expecting ']' in C:\Network\Apache2\htdocs\request\forumdisplay.php (705) : eval()'d code on line 1

Any ideas ?

[mr e]

what's line 705 and probably a few lines before and after

[fla5h]

line 705 is

PHP Code:

 eval("\$sortarrow[$sortfield] = \"".gettemplate('forumdisplay_sortarrow')."\";"); 


The rest above is unhacked / unaltered.

If i "//" out the eval the error disappears.