please help....

[Anon]

Hi,I have a table that has a fields $category,$description,$image,$price...etc etc

What i am trying to do is display the categories as links. The categories are not table names but a variable, but at the moment the more entrys in the db that have the same category show up as links (eg there is three links that show the Jewellery info). How can i get rid of this repetition so it will show the link only once???....hope you can follow this explanation...thanks for your help

$db = mysql_connect("localhost", "root");

mysql_select_db("new",$db);

$result = mysql_query("SELECT * FROM general",$db);

while ($myrow = mysql_fetch_array($result)) {

printf("<a href=\"$PHP_SELF?catagory=$myrow[catagory]&go=yes\">%s </a><br>", $myrow["catagory"]);

[techek]

I would use GROUP BY in MySQL by grouping on eg. the attribute "category_name" (not "category_id" which is unique anyway!)

Go have a look at www.mysql.com in the documentation on how to use GROUP BY

/Techek

[Anon]

Thanks for that, it was a lot easier than i thought.