Instances....help please

[Anon]

Hello, i have a page with links on it that are generated by the a catagory field in my db. So selecting one of these links will show images and descriptions in that catagory, except that it is showing multiple instances of the catagory links. How do i change my code so that it only echos one instance of the catagory? thanks stu

$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"]);

[[deleted]]

not sure i understand the question, but if you just want one record from your database you can write

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

then you don't need the while loop too. But i'm not sure that answered your question..

[sglane]

You could take the while out. Leave it as :

$myrow = mysql_fetch_array($result);

[Anon]

Sorry description of my problem was no the best.I have a table that has a $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, so the more entrys in the db that have the same category will show as a repetition. How can i get rid of this repetition so it will show the link only once....hope this is a better explanation...thanks for your help