Help Echoing Out A Select Query

[golfinggod]

Hi
All Im trying to echo the information Day from my database which currently contains multiple rows, the problem is im not sure how to go about it. This is as far as ive got.

$link = mysql_connect('************', '**********', '********');

					mysql_select_db("db95934936"); 

				    // Performing SQL query 

					$query = "SELECT * FROM FreeRolls"; 

					$result = mysql_query($query) or die("Query failed : " . mysql_error()); 


					echo $result[0];

I try but get no comeback and no error, im also not sure how to cho muliple rows.

[scorpioy]

replace you last line: echo $result[0];
by:

if ($myrow = mysql_fetch_array($result)) 
{	
     do {
                echo $myrow[0];

} while ($myrow = mysql_fetch_array($result));

} 
else {
	echo "No records !";
}

it is able to retrieve multiple rows in column 0.