Sorting problem

DisOrDeR1337

Does anyone know why this sorts alphabetically backwards?
And how to make it go a-z, not z-a

ORDER BY email DESC

Aaron

searain

ORDER BY email DESC

did you ask it to sort by reverse order by specifying "DESC"?

DisOrDeR1337

I guess what im asking is what exactly does that DESC do?

searain

The default is to return the results in ascending order (top to bottom).

If you include the DESC keyword in the ORDER BY clause, the rows are returned in descending order (bottom to top).

DisOrDeR1337

oh, i just take that out, weird, it was bombing out when i had it out before...
this is how I have it

<?
/*
This section sets the value for the Sort by value
*/
if( $sort == "" ) 
$sortvar = " "; 
else 
$sortvar = " ORDER BY $sort"; 
$hreffiller =  "$PHP_SELF?location=$location";
/*
This section that pulls the value
*/
$result = mysql_db_query ("$dbname","select * from $dbTable WHERE email LIKE '%@%' AND email LIKE '%.%' AND send='1' $locvar $sortvar");
		while ($row = mysql_fetch_array ($result)) 
		{

/*
This is the part that sorts it accordingly
*/?>
<table border="1" cellspacing="2" cellpadding="2" bordercolor="#000000">
    <tr> 
      <td class="titel"><b><a href="<? echo "$hreffiller" ?>&sort=id">Nb</a></b></td>
    <td width="155" class="titel"><b><a href="<? echo "$hreffiller" ?>&sort=fname">First Name</a></b></td>
    <td width="155" class="titel"><b><a href="<? echo "$hreffiller" ?>&sort=name">Last Name</a></b></td>
<td width="155" class="titel"><b><a href="<? echo "$hreffiller" ?>&sort=location">Location</a></b></td>
<td width="100" class="titel"><b><a href="<? echo "$hreffiller" ?>&sort=date">Date</a></b></td>
	<td width="210" class="titel"><b><a href="<? echo "$hreffiller" ?>&sort=email">E-Mail</a></b></td>
      <td class="titel"><b>Delete</b></td>
  </tr>

anyone know anything more efficient?