List category ID's

[Apathetic]

I want to list all the categories in a page. Each posts have a column with their corresponding category id (numerical). Now how do i list all the categories in a page?

$db = mysql_connect(HOST,UNAME,PASS);
mysql_select_db(DBNAME);
$query = mysql_query("select * from POSTS");
while($row = mysql_fetch_object($query)){
    switch($row->category){
    case 1: echo 'Category A';break;
    case 2: echo 'Category B';break;
    case 3: echo 'Category C';break;
    case 4: echo 'Category D';break;
    case5: echo 'Category E';break;
    default: echo 'Uncategorized';
} 

unfortunately this code displays the category everytime it exists

Apathetic Reviewed by Apathetic on 29th Oct 2011. List category ID's I want to list all the categories in a page. Each posts have a column with their corresponding category id (numerical). Now how do i list all the categories in a page? $db = mysql_connect(HOST,UNAME,PASS); mysql_select_db(DBNAME); $query = mysql_query("select * from POSTS"); while($row = mysql_fetch_object($query)){ switch($row->category){ case 1: echo 'Category A';break; case 2: echo 'Category B';break; case 3: echo 'Category C';break; Rating: 5

[Apathetic]

WOoooooPPPzzzz:

select distinct category from posts 

[t3od0r]

you can try

$query = mysql_query("select * from POSTS group by category");