<?php mysql_connect("mysql153.secureserver.net","navioo","password"); mysql_select_db("navioo"); $query = "SELECT id, firstname FROM Employee"; $result = mysql_query($query); for ($count=0; $count <= mysql_numrows($result); $count++) { $id = mysql_result($result, $count, "id"); $name = mysql_result($result, $count, "firstname"); echo "$firstname ($id) <br />"; }?>