retriveing link list for navigation from mysql database

xerof

i seem to be having some problem im not sure whats wrong what i have so far is this:
lines 90-97

<td height="20" valign="top">
<?
while($row = @mysql_fetch_array($result)) {
$name = $row["name"];
$url = $row["url"];
?>
<?php printf("<a href=\"$url\">$name</a>"); ?>
</td>

lines 291-297

<?php
$members->Close();
$members_url->Close();
$members_alldata->Close();
$members_publicdata->Close();
$url->Close();
?>

the problem im having is that i get the following error:

Parse error: parse error in /home/gottvonk/public_html/memberlist.php on line 297

any help would be greatly apreciated.

azkworld

I can definitely see an error with @mysql_fetch_array -- you don't need a @ there, simply:
$row = mysql_fetch_array($result)

Maybe the parser gets thrown off by that @ and misreports the line # where error is?

Weedpacket

I don't see any syntax error in those lines you posted (no, although the @ isn't necessary, it's not causing the problem either). Are you sure the code you've posted is a straight cut-and-paste from the offending script?

If that's the last bit of PHP on the page, then chances are you've got an unmatched { floating around somewhere higher up.

Oh, and here's a question - when did $url become an object with a Close() method? In the other bit of code it's a string.

xerof

heres the link to the complete code for the page any help is apreciated, thanks.
http://gottvonkriege.com/open/code.txt

Weedpacket

Yep, I was right. You never finish your loop.