There are two ways to retrieve the number of rows selected from a database; either by using the PHP function mysql_num_rows() or by using the SQL COUNT() Function. Take a look at the following :

1. Using PHP
   

       $query = "SELECT (column) FROM table WHERE column = value";
       $results = mysql_query($query);
       $rows = mysql_num_rows($results); 
       echo $rows ;

2. Using SQL
   

      $query = "SELECT COUNT(column) FROM table WHERE column value";
      $results = mysql_query($query);
      $rows = mysql_fetch_array($results);
      echo $rows[0];

New Joomla! update is available ver 1.5.14 This is mainly released to fix 2 issues on the TinyMCE Editor and the Media Manager. After upgrading to 1.5.13 user got this error when trying to access com_media :

It also contains one low-level security fix to the com_mailto.

Big Thanks to bug squad team and everyone participated on this update. It has been only 8 days since 1.5.13 was released!!

• Download the full 1.5.14 package.
• Update from previous Joomla! versions.

To upgrade simply download the apropriate release, extract it on your computer and upload it to replace the old files. Don't forget to backup your website first!

sh404SEF is a Joomla! extension helps you creating better SEF URLs. It's full of features and parameters that helps you to acheieve the format you want for your Joomla! website. On July 24^th 2008 the JED editors announced that sh404SEF has been added to the editors' pick. Development cycle continued and sh404SEF became one of the must have extensions.

New Joomla! update is available ver 1.5.13 It contains fix for 26 bug, two moderate-level security fixes, and one low-level security fix.

Thanks to bug squad team and everyone participated on this update. It has been only 3 week since 1.5.12 was released!

• Download the full 1.5.13 package.
• Update from previous Joomla! version.

To upgrade simply download the apropriate release, extract it on your computer and upload it to replace the old files. Don't forget to backup your website first!

Alen Grakalic wrote:

Tablecloth is lightweight, easy to use, unobtrusive way to add style and behavior to your html table elements. By simply adding 2 lines of code to your html page you will have styled and active tables that your visitors will love

Tablecloth is provided by CSS Globe.

I created a modified version allowing the user to specify a class for the tables he want to style. After commenting about it some users asked me to share it.

Download the modified version, edit the config on the CSS file and enjoy nice more usable tables on your website!