<?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());

if($result) {
    while($row = mysql_fetch_array($result)){
        $index = $row['Index'];
        echo 'Index: ' . $index;
    }
}

//$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;
//}
?>