Pagination w/ >1 table field echoed

[sKunKbad]

My pagination works, I have this:

[code]if (!isset($_GET['page'])){
  $page = 1;
} ELSE {
  $page = $_GET['page'];
}
$max_results = 10;
$from = (($page * $max_results) - $max_results);
$sql = mysql_query("SELECT * FROM localdirectory LIMIT $from, $max_results");                                
                                          
while($row = mysql_fetch_array($sql)){                                
echo $row ['name']."<br/>";[/code]

which is all good, but it only outputs the name field of my database, I want to be able to output all of the other fields, like ['address'],['city'],['st'],['zip']. I've tried adding that in various ways, but can't get it to work.

I can't figure it out. Please help.

Thanks for your help!

[khendar]

[code]
while($row = mysql_fetch_array($sql))
{                                
echo $row ['name']."<br/>";
echo $row ['address']."<br/>";
echo $row ['city']."<br/>";
echo $row ['st']."<br/>";
echo $row ['zip']."<br/>";
}

[/code]

Doesn't work ?