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

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'php';
mysql_select_db($dbname);

$result = mysql_query("SELECT * FROM statuses")
or die(mysql_error());

$row = mysql_fetch_array( $result );
$loop = 0;
$amount = mysql_num_rows();
while($loop < $amount){
//echo "Index: ".$row['Index'];
//echo "Status Type: ".$row['Status type'];
//echo "Colour: ".$row['Colour']."\n";
$loop = $loop + 1;
echo $loop;
echo $amount;
}
?>