[RESOLVED] query results only giving second last row

This site is best viewed in a modern browser with JavaScript enabled.

[RESOLVED] query results only giving second last row

wsparrow

Hi,

Having a weird issue here. Just trying to query a table for a list of files and echo the results, but for some reason, I'm only getting the second last row, regardless of how many files are in the table. This is pretty basic, can't see where the problem is

$newf = mysql_query("SELECT * FROM UploadedFiles");
while ($new = mysql_fetch_array($newf)) {
		echo '<p><a href="ed1.php?name=' . ($new['name']) . '>' . ($new['name']) . '</a></p>';
}

Any thoughts?

Thanks

bionoid

Missing a closing quote, otherwise it looks fine:

$newf = mysql_query("SELECT * FROM UploadedFiles");
while ($new = mysql_fetch_array($newf)) {
        echo '<p><a href="ed1.php?name=' . ($new['name']) . '[COLOR="Red"]"[/COLOR]>' . ($new['name']) . '</a></p>';
}

wsparrow

Oops. Found it. Missing double quote....

wsparrow

haha thanks. Just saw that myself.