Loading navigation from MySQL table

[sciwaysoft]

I am loading my navigation from a mysql table. i have two fields in my "nav" table subid and linkcaption. I am using this code

for($counter = 1; $counter <= 10; $counter = $counter + 1)
{
$result = @("select linkcaption from nav where subid='1$counter'");
$row = mysql_fetch_array($result);
$caption=$row['linkcaption'];
echo ("<tr><td><a href='index.php?p=1$counter'>$caption</a></td></tr>");
}

The question is that if it is ok with query to be called every time the for loop is triggered ( i think it will slow down the page). Is there any method i can do this in a better manner

[Pig]

A better route would be to specify the parameters in the WHERE clause, and then just loop through them. Not sure what your parameters would be, but you could do:

$result = mysql_query("select linkcaption, subid from nav where subid >= 11 AND  subid <= 20");
while( $row = mysql_fetch_array($result) )
{
     echo ("<tr><td><a href='index.php?p=$row[subid]'>$row[linkcaption]</a></td></tr>"); 
}