[SOLVED] Sorting data from a database

[datalee100]

I've tried to do this several times and things just seem to be getting uglier and uglier...  I have this code in place to show members:

 

<?php $result2=mysql_query("SELECT * FROM $tablename") or die(mysql_error());

while($row=mysql_fetch_array($result2)) {
echo "<tr><td>$row[tcgname]</td><td>$row[name]</td><td>$row[subject]</td><td><a href=\"$row[siteurl]\"><img src=\"$row[urlbanner]\" border=\"0\"></a></td></tr><tr><td><u>Description</u>: </td><td colspan=\"3\">$row[about]</td></tr><tr><td colspan=\"4\">--------------------------------------------------------</td></tr>"; }

 

But my goal is to change it so that it puts the list in alphabetical order by the row that has the tcg name in it or tcgname.  Is there a way to do this correctly?  Thanks in advance!

[roopurt18]

  SELECT * FROM table WHERE 1 ORDER BY col1, col2, ..., colN

[datalee100]

Thanks, I think...  I used an ORDER by name ASC instead of what you said, but I think the advice you gave me spurred me to the right idea...  So, Thanks!  Topic Resolved!