Retrieving the data out of mysql DB?

[Wrath]

Hey I was wondering if someone could help.

I'm just starting and not very good but here's what I'm trying to use to retrieve the info from my DB

<?

// DATABASE HOOK UP

$db = mysql_connect("localhost", "DB User", "DB password");
mysql_select_db("DB");

// THE CRAP

$result = mysql_query("SELECT * FROM comments");
while ($myrow = mysql_fetch_array($result)) { printf($myrow[name], $myrow[email], $myrow[comments]);
}

?>

But all that shows up when I go to the page is the name in the database but the email or comments don't show up though.

Any help fast would be appreciated. 🙂

[cgraz]

try this

$result = mysql_query("SELECT * FROM comments"); 
while ($myrow = mysql_fetch_array($result)) { 
   print $myrow["name"] . ", ";
   print $myrow["email"] . ", "; 
   print $myrow["comments"]; 
} 

Cgraz

[Wrath]

thanks alot. 🙂 Works fine now.