only display category once

[wazo]

Hi guys

I'm calling categories from my knowledge table


problem is is i only want the category to display once on this page

http://www.notexperienced.co.uk/support.php


as you can see Managing Your CV displays twice

<? 


$sql = ("select * from knowledge WHERE type ='Jobseeker' ORDER BY category ASC");






              $result = mysql_query ($sql);

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



  $title = $row["category"];

 


echo "<a href=\"viewsupport.php?category=$title&type=Jobseeker\">$title</a><br>";



  }






?>

How can i change it so it only displays once

[Mittineague]

If you only want 1 to show try

$sql = ("select * from knowledge WHERE type ='Jobseeker' ORDER BY category ASC LIMIT 1");
              $result = mysql_query ($sql); 
              if ($row = mysql_fetch_array($result)) 
              { 

[wazo]

I tried that but didnt work

[byron3@earthlink]

sql = ("select DISTINCT category from knowledge WHERE type ='Jobseeker' ORDER BY category ASC"); 

[darksystem]

you can even try this

$sql = ("select * from knowledge WHERE type ='Jobseeker' ORDER BY category ASC");

$row = mysql_fetch_array($sql);

echo "<a href=\"viewsupport.php?category=$row['category']&type=Jobseeker\">$title</a><br>";

[optl]

If you only want to show one result do this:

you can even try this

$sql = ("select * from knowledge WHERE type ='Jobseeker' ORDER BY category ASC");

$row = mysql_fetch_array($sql);

echo "<a href=\"viewsupport.php?category=$row['category']&type=Jobseeker\">$title</a><br>";

If you want each category to only show once then use the DISTINCT category trick posted above.

[darksystem]

Agreed - (if he just wants to display the category once)