You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-commits@incubator.apache.org by sh...@apache.org on 2008/10/20 20:13:34 UTC

svn commit: r706398 - /incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php

Author: sheetal
Date: Mon Oct 20 13:13:34 2008
New Revision: 706398

URL: http://svn.apache.org/viewvc?rev=706398&view=rev
Log:
updating Tags_Controller.php under php webapp

Modified:
    incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php

Modified: incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php
URL: http://svn.apache.org/viewvc/incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php?rev=706398&r1=706397&r2=706398&view=diff
==============================================================================
--- incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php (original)
+++ incubator/olio/webapp/php/trunk/controllers/Tags_Controller.php Mon Oct 20 13:13:34 2008
@@ -26,7 +26,8 @@
  */
 class Tags_Controller {
     function getHomePageTagCloud($connection) {
-         $cloudquery = "(SELECT st.tag as tag,st.refcount as count from SOCIALEVENTTAG as st where st.refcount>100 limit 50)  order by tag ASC";
+         //$cloudquery = "(SELECT st.tag as tag,st.refcount as count from SOCIALEVENTTAG as st where st.refcount>100 limit 50)  order by tag ASC";
+         $cloudquery = "(SELECT st.tag as tag,st.refcount as count from SOCIALEVENTTAG as st order by st.refcount desc limit 50) order by tag asc";
          $cloudresult =$connection->query($cloudquery);
          $rowsFound = false;
          while ($row = $cloudresult->getArray()) {