Using Select Distinct

[fire_cracker]

I am trying to use the select distinct feature in a stats program I am writing. I want it to first select the distinct pages listed in the table, then output a link that will show the work for that one page. Here is the code that I have thus far, please let me know how to make it work 🙂

$query1 = mysql_query("SELECT DISTINCT page FROM fpu_stats");

$while ($row1 = mysql_fetch_array($query1)) {
$page = $row1[page];
?>
<tr>
<td align="left" valign="center"><a href="stats.php?page=<? echo $page ?>"><? echo $page ?></a></td>
</tr>
<?
}
?>

Thanks everyone

[LordShryku]

What isn't working?

[bastien]

It would elp if you were to list what the problem(s) is...

[fire_cracker]

Whoops, I forgot to mention that part.

I am getting an error on the line with the While code in it. I think it is related to the bracket starting the while statement, because whenever I move it around, the error moves with it.

[LordShryku]

Remove the $ before while

[oprpg]

why do you have a $ before while?

while ($row1 = mysql_fetch_array($query1)) {