Try this code maybe it helps
<?php
$con = mysql_connect("yourhostname","youruserid","password");
mysql_select_db("world");
$result = mysql_query("SELECT * FROM Country",$con) or die(mysql_error());
echo mysql_num_rows($result);
while($row = mysql_fetch_array($result)) {
echo $row['Code'] . "---" . $row['Name'];
echo "<br>";
}
?>
</br>