Showing MySQL rows in a PHP file

[firstrebel]

<?php

// change hostname, username and password, dbname

if(!isset($query) || empty($query))
	($query= "select coderid,codername,codercountry from coders order by coderid asc");	
	$query = stripslashes($query);
	$db_link = mysql_connect('hostname', 'username', 'password')
  		or die("Could not connect to database. Please try again later.");
	mysql_select_db('dbname') or 
		die("could not connect to database");
	$result = mysql_query($query) or	
		die( mysql_error() );
	$number_cols = mysql_num_fields($result);
	
	echo "<table width=740  border=1 align=center cellspacing=0 cellpadding=5>\n";
	echo "<tr align=center>\n"; 
	echo "<font face=arial>";
	echo "<font size=-1>";	
	for ($i=0; $i<$number_cols; $i++)
	{
		echo "<th>" .mysql_fieldname($result, $i). "</th>\n"; 
	}
	echo "</tr>\n";
	
	while ($row = mysql_fetch_row($result))
	{
		echo "<tr align=left>\n";

		for ($i=0; $i<$number_cols; $i++)
		{
			echo "<td>";
			echo "<font face=verdana>";
			echo "<font size=-1>";		
			if (!isset($row[$i]))
				{echo "n.a.";}
			else 
				{echo $row[$i];}
			echo "</td>\n"; 
		}
		echo "</tr>\n";
	}
	echo "</table>";
	echo "</font>";
      mysql_close($db_link);
?>