Last Name: '; } else { $link = my_connect(); $result = run_query("SELECT * FROM Players WHERE lastname like '".$last."%'"); // Printing results in HTML echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo ''; echo ''; echo ''; echo ''; echo ''; } echo "
First NameLast NameAction
',$line['firstname'],'',$line['lastname'],'[Edit] '; echo '[X]
\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); } require("footer.html"); ?>