Need help with simple query

[JRockfl]

I need help displaying a simple query.
This is what I have so far....I need help with the output part...

<?php

// Connect to database server
$user="jrockfl";
$host="localhost";
$password="ja21son";
$database="new_db";
$connection = mysql_connect($host,$user,$password)
or die ("Couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

// Request all from the code snippets table
$query = "SELECT * FROM code_snippet";
$result = mysql_query("example", $query);

ok...what comes next? i just want to display all the results
my fieldnames are snippetid, snippet and code

[cgraz]

// Request all from the code snippets table 
$query = "SELECT * FROM code_snippet"; 
$result = mysql_query("example", $query); 

// create array $row holding all the results from your query
while($row = mysql_fetch_array($result)) {

// display results
print "Snippet ID: " . $row["snippetid"] . "<br>\n";
print "Snippet: " . $row["snippet"] . "<br>\n";
print "Code: " . $row["code"] . "<br>\n";

// end while loop
}

Cgraz

[JRockfl]

it worked! thank you