$sortorder for multiple fields

[Sarcoth]

Is there an easy way to set the $sortorder for multiple fields. Right now I have my $sortorder set to default on usergroup.title. The page comes up correctly with the titles put in the correct order, but then it puts the members in userid order. I'd like it to instead put them in username order (alphabetically). And, if I sort by another field, I always want the username order (alphabetically) to be my secondary order.

Here is what I have right now:

	$sorturl = 'shroster.php?' . $vbulletin->session->vars['sessionurl'];
	$sortfield = $_REQUEST['sort'];
	$sortorder = $_REQUEST['order'];
	
	if ($sortfield == '')
	{
		$sortfield = 'title';
	}
	if ($sortorder == '')
	{
		$sortorder = 'asc';
	}

Here is my query:

	$users = $db->query_read_slave(" 
		SELECT user.*, shroster_roster.*, usergroup.usergroupid, usergroup.title, user.options, usertextfield.*, userfield.*, 
		IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
		FROM " . TABLE_PREFIX . "usergroup AS usergroup 
		LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)) 
		LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid) 
		LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=user.userid) 
		LEFT JOIN " . TABLE_PREFIX . "shroster_roster AS shroster_roster ON(shroster_roster.shCharID=userfield.field7)
		WHERE (usergroup.shrosterviewpermissions = 1)
		ORDER BY " .$sortfield. " " .$sortorder
	);

Any thoughts?

I appreciate any assistance.

Thank you!

	if ($sortfield == '')
	{
		$sortfield = 'title, shname';
	}
	if ($sortorder == '')
	{
		$sortorder = 'asc';
	}

Upon further testing, adding (, shname) to the above fixed the initial sorting to the way I wanted it.

I still have a problem when trying to sort different columns though.

Here's a bit from my template.

<a href="$sorturl&amp;order=asc&amp;sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" border="0" /></a>&nbsp;
  	  	$vboptions[shCharName]&nbsp;
  	  	<a href="$sorturl&amp;order=desc&amp;sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortdesc.gif" border="0" /></a></td></if>
  	  <if condition="$show['title']"><td class="thead" nowrap>$vboptions[shTitle]</td></if>
  	  <if condition="$show['rank']"><td class="thead" nowrap>
  	  	<a href="$sorturl&amp;order=asc&amp;sort=title"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" border="0" /></a>&nbsp;
  	  	$vboptions[shRank]&nbsp;
  	  	<a href="$sorturl&amp;order=desc&amp;sort=title"><img class="inlineimg" src="$stylevar[imgdir_button]/sortdesc.gif" border="0" /></a></td></if>

If someone clicks on the ASC or DESC sort for title, I want to make sure it sorts title first and then shname. I tried the following but that only made it it sort by shname and ignore the title.

  	  <if condition="$show['rank']"><td class="thead" nowrap>
  	  	<a href="$sorturl&amp;order=asc&amp;sort=title&amp;order=asc&amp;sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortasc.gif" border="0" /></a>&nbsp;
  	  	$vboptions[shRank]&nbsp;
  	  	<a href="$sorturl&amp;order=desc&amp;sort=title&amp;order=asc&amp;sort=shname"><img class="inlineimg" src="$stylevar[imgdir_button]/sortdesc.gif" border="0" /></a></td></if>

Any idea's?