<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'test';

$conn = mysql_connect($dbhost, $dbuser, $dbpass)
        or die ('Error connecting to mysql');
echo $conn;
$selected = mysql_select_db($dbname, $conn);
/*$selected = mysql_select_db($dbname);*/



$result = mysql_query("
                SELECT
                  *
                FROM
                  `customers`
              ");

              echo"<table>
                    <tr>
                      <th>ID</th>
                      <th>Meno</th>
                      <th>Priezvisko</th>
                      <th>Tel. Cislo</th>
                      <th>Poznamka</th>
                    </tr>";

              $i = 1;
              echo mysql_error();

              While ($arr = mysql_fetch_assoc($result))
              {
              	echo"<tr>
                      <td>" . $arr['ID'] . "</td>
                      <td>" . $arr['name'] . "</td>
                      <td>" . $arr['surname'] . "</td>
                      <td>" . $arr['phone'] . "</td>
                      <td>" . $arr['note'] . "</td>
                    </tr>";
                $i++;
              } // end while..

              echo"</table>";


mysql_close($conn);
?>