download by file id

[chris11]

What ive done is upload a fie to my server and categorized it in mysql with an id name.

 

Im trying to fetch that file by calling for the id name "download.php?id=" and print or echo it a link with the file name not id number. This is what im working with and am getting an Parse error: syntax error, unexpected '<' in /home... on line blue

<?php
$query = "SELECT id, name FROM uploads";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
while(list($id, $name) = mysql_fetch_array($result))

[color=blue]<a href="download.php?id=<?php echo urlencode($id);?>"><?php echo urlencode($name);?></a> <br>[/color]
}
?>

 

So yeah. Ive been messing around with it and I magically fix one error only to refresh to another .

 

Any insight would be awesome.

 

Thanks

[waynew]

This should work:

<?php
$query = "SELECT id, name FROM uploads";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0){
echo "Database is empty <br>";
}
else{
while(list($id, $name) = mysql_fetch_array($result)){
	echo '<a href="download.php?id='.$id.'">'.$name.'</a><br />';
}
}
?>

[chris11]

thanks. that fixed everything