a grandi linee:
codice:
$conn = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$query = "SELECT * FROM tabella";
$rs = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($rs);
if ($num != 0) {
    while ($row = mysql_fetch_array($rs)) {
        //....
    }
} else {
    echo "No records";
}