<?php
$host = "";
$user = '';
$pass = '';
$db = "";

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

mysql_select_db($db) or die ("Unable to select database!");

$query = "SELECT * FROM table";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

$id = 1;

// see if any rows were returned
if (mysql_num_rows($result) > 0) {
    // yes
    // print them one after another
    echo "<table cellpadding=10 border=1>";
    while($row = mysql_fetch_row($result)) {
        echo "<tr>";
        echo "<td>".$id."</td>";
        echo "<td>".$row[0]."</td>";
        echo "</tr>";
        $id++;
    }
    echo "</table>";
}
else {
    // no
    // print status message
    echo "No rows found!";
}

// free result set memory
mysql_free_result($result);

// close connection
mysql_close($connection);
?>