Whats the best way to cycle through a fetch array?

[Keaner]

Just wondering how'd I'd use fetch and then go though the array. For example if I wanted to print out each record in a database? Not just one singluar record.

[Jimmy79]

How about something like

$link = @mysql_connect($db_server,$db_user,$db_pw);

mysql_select_db($db_name);
mysql_query($sql);

while ($info = mysql_fetch_array($result, MYSQL_ASSOC))
{
    # $info is an array that contains every column in your row
    print_r ($info);
}

mysql_close($ink);

I find that this is the kind of thing that's worth encapsulating in a class (personal opinion).