"; // form the query for selecting info from accounts $query="SELECT * FROM accounts ORDER BY name"; $result = mysql_query($query); $num_rows = mysql_num_rows($result); $i=0; while ($i < $num_rows) { $id5 = mysql_result($result, $i, "id"); $name5 = mysql_result($result, $i, "name"); echo "$name5"; } echo ""; mysql_close(); ?>