Logout $sqlhostname = "mfmedina.fatcowmysql.com"; $login = "mfmedi01"; $password = "tt031802"; $base = "spanish"; $db_connect = mysql_connect($sqlhostname,$login,$password); $base_selection = mysql_select_db($base,$db_connect); $query = "SELECT * FROM span403_roster ORDER by apellido ASC"; $req = mysql_query($query); if (!$req) { echo "Error ".mysql_errno()." : ".mysql_error().""; exit; } $res = mysql_num_rows($req); if ($res == 0) { echo "
- ";
{ while($row = mysql_fetch_array($req))
{
extract($row);
echo "
-
$nombre $apellido
"; } mysql_free_result($req); } echo "