MySQL infinitely returns the same record

[Anon]

for some reason, this code makes MySQL keep returning the same record. help!

echo "<ul>";
while ($link = mysql_fetch_array(mysql_query("SELECT * FROM agendas ORDER BY date"))) {
echo "<li><a href=\"agendas.php?id=" . $link['id'] . "\">Meeting " . $link['id'] . " (" . $link['date'] . ")</a>";
}

echo "</ul>";

[Anon]

Because that's the way it's been coded. It does a new query each time through the loop and will always return the first record. Put mysql_query() outside the loop.

[Anon]

k...thanks...it was the first time i had ever attempted it in that manner.