Having trouble with sorts

[ntburchf]

Having trouble getting data to sort

<?php
include("admin/config.inc.php");
//MySQL Part
$db_con = mysql_connect($hostname,$username, $password) or die("Connetion to database failed!");
mysql_select_db($dbname);
$query = "select * from ".$table;
$result = mysql_query($query);
$i = 0;
while ($i < mysql_num_fields($result))
{
    $meta = mysql_fetch_field($result);
    $columns[$i] = $meta->name;
    $i++;
}

echo "<table border=1 width=90%>";
echo "<tr><td colspan=".(sizeof($columns)).">";
echo "<table border=0 width='100%'><tr><td class='small' bgcolor='#000000'>";
echo "<font color='#ffffff'><center>
<p>Ban List Records Table </p>
</td></tr></table></td></tr><tr>";
for($i=1;$i<sizeof($columns);$i++)
{
echo "<td class='small'><center><b>".$columns[$i]."</td>";
}
echo "<td class='small'><center>
</td></tr>";


// Do I add the sort here ?
// like this
//Tried a couple ways it errors out, so I am sure my syntax is wrong
//$query = "select id, username, admin, offense, server from ".$table ORDER BY username;
//

$query = "select id, username, admin, offense, server from ".$table;
$result = mysql_query($query);
$j=0;
while($row=mysql_fetch_array($result))
{
echo "<tr>";

for($i=1;$i<sizeof($columns);$i++)
echo "<td class='small'><center>".$row[$columns[$i]]."</td>";

$j=$row[$columns[0]];
echo "<td class='small'><center>
<p>
</tr>";
}
echo "</table>
<p>";

//MySQL ends
//
?>

[eoghain]

Your query syntax is fine it's your PHP syntax that has the problem:

// Do I add the sort here ?
// like this
//Tried a couple ways it errors out, so I am sure my syntax is wrong
//$query = "select id, username, admin, offense, server from ".$table ORDER BY username;
//

$query = "select id, username, admin, offense, server from ". $table . " ORDER BY username";

In the commented code you aren't opening up your string to add the ORDER BY clause.

[ntburchf]

I knew it was something simple..
Thanks
Regards
TB