Help displaying my query results

[barman]

To start here's my query code which works fine for what I want it to do.

<?php

require('datas/connect.php');

$result = mysql_query("select * from ldu_hackers order by name");

while($r=mysql_fetch_array($result))
{	

   $name=$r["name"];
   $level=$r["level"];
   $char=$r["char"];
   $server=$r["server"];
   $desc=$r["desc"];
   $id=$r["id"];

   echo "$name | $level | $char | $server | $desc <br>";

}
?>

But instead of just echoing the info here, I was wondering can someone show me how to have an html table file or have this file grab the info from this query and display it in a table.

[Weedpacket]

To just display it as a table is trivial: just put the appropriate HTML tags in the echo statement. (and echo "<table>" and "</table>" before and after the loop respectively).

You could put the results in an array:

$ldu_hackers = array();
while($r = mysql_fetch_assoc($result))
{
  $ldu_hackers[] = $r;
}

And from there on do whatever you like with the $ldu_hackers array. Including displaying it or writing it to a file in whatever format takes your fancy.