automating the creation of new html documents

<table border="2" bordercolor="#FF9900" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Name</font></th>
</tr>

<?php
// deletestudents.php - a customised php page that works from a snippet call to list web users in the
// database and provide functionality for the students to be deleted from the database
// author: sarah vardy

	// Establish a connection to the MySQL DBMS
	$connection = mysql_connect("localhost", "root", "s0laspie");

	// Use the modx database
	mysql_select_db("modx", $connection);


   	// Run a query through the connection
   	$result = mysql_query("SELECT id, username FROM modx_web_users ORDER BY id", $connection);
  
   
   	//run the while loop that grabs all the web users
  	while($r=mysql_fetch_array($result)) 
   	{ 
      	//grab the title and the ID of each user
      	$username=$r["username"];//take out the title
      	$id=$r["id"];//take out the id
     
	 	  	?><tr><td bgcolor="#CCCCCC" ><div align="center"></div>
			<?php
		//make the title a link
      	echo "<a href='index.php?id=48'>$id \t $username</a>";
		?>
		</td>
		</tr>
		</div>
		<?php
	}   		
?>

<?
echo "</table>";
?>