<?php $connection = mysql_connect(localhost,USER,PASSWORD); $db = mysql_select_db(DATABASE, $connection); $sql = "SELECT id,username FROM TABLE"; $result = mysql_query($sql); //$link = "<a href='profile.php?id=$row[id]'>"; //uncomment $link and $el if you want it linkable $td = "<td>"; //$el = "</a>"; echo "<table border=0 cellspacing=0 cellpadding=2 width=200>"; echo "<tr><td>ID<td>Username"; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { echo "<tr><td>"; printf ("%s $td $link %s $el", $row[0], $row["username"]); } mysql_free_result($result); ?>
Home
