Arranging Titles

[ballouta]

Hello

I will try to describe my problem briefly.

I have this table (Books)

 

ID    bname  author  version    language  isbn              cat

==    =====  ====    =====    ======  ====            ===

51    firstbok  aut1    1            en-fr      9786915484    biography

.... etc

 

I have around 400 books with 21 categories

 

I want to view these categories titles ONLY according to highest publications under these categories

e.g.:

 

Biography (145)

History (130)

etc...

 

thank you very much

[rhodesa]

try...

SELECT `cat`,count(*) as num FROM `Books` GROUP BY `cat` ORDER BY num DESC

[ballouta]

waaw it is working

 

I printed the categories and it is correct, but how do I print 'num' value in the while loop i am using?

<?php
$result = mysql_query(" SELECT `cat`,count(*) as num FROM `books` GROUP BY `cat` ORDER BY num DESC");
while( $row = mysql_fetch_array($result) )
{
echo "$row[cat] () <br>";
}

 

How i print number of books in each catgeory in the brackets?

thank you

[wildteen88]

How i print number of books in each catgeory in the brackets?

 

Change your echo statement in your while loop too:

   echo $row['cat'] . ' ('.$row['num'].') <br>';

[rhodesa]

yeah, you should use single quotes around your array keys like wildteen88 describes. i like to do it this way (cleaner in my eyes):

 

printf('%s (%s)<br />',$row['cat'],$row['num']);