Sorting MySQL ??

wxdqz · Aug 20, 2008

Can someone tell me how to make this script list the priority so that the highest (1) is at the top and the lowest (4) is at the bottom?

Thanks

Heres what i currently have:

<?
function mydbconnect ($hostname,$username,$password,$dbname)
{
$link = @mysql_pconnect("$hostname","$username","$password");
if ($link && mysql_select_db ("$dbname"))
return ($link);
return (FALSE);
}
?>

<?
mydbconnect($hostname,$username,$password,$dbname);

$query = "SELECT * FROM $tablename";

$exec = MYSQL_QUERY($query);

echo '

<head>
<title>HelpDesk Admin Interface</title>
</head>

<body>

HelpDesk Admin
Interface
<div align="center">
<center>
<table border="1" cellspacing="0" bordercolorlight="#000000">
<tr>
<td> Ticket
Number  </td>
<td> UserName  </td>
<td> Name  </td>
<td> Email  </td>
<td> Domain  </td>
<td> Priority  </td>
<td> Status  </td>
<td> Date
Submitted  </td>
</tr>
';
while ($row = mysql_fetch_array ($exec)) {
echo '<tr>';
echo '<td align="center">  ' . $row["ticket"] . '  </td>';
echo '<td align="center">  ' . $row["user"] . '  </td>';
echo '<td align="center">  ' . $row["name"] . '  </td>';
echo '<td align="center">  ' . $row["email"] . '  </td>';
echo '<td align="center">  ' . $row["domain"] . '  </td>';
echo '<td align="center">  ' . $row["priority"] . '  </td>';
echo '<td align="center">  ' . $row["status"] . '  </td>';
echo '<td align="center">  ' . $row["date"] . '  </td>';
echo '</tr>';
}
echo '
</table>
</center>
</div>
Click on a Ticket Number to view the problem 
Once chosen the ticket can be closed and the solution 
displayed to the user.

</body>

';

mysql_free_result ($exec);
MYSQL_CLOSE();

?>

Sorting MySQL ??

wxdqz

New Member