[xc-tokai-svnlog] SF.net SVN: xc-tokai: [113] modules_cqa/trunk/blocks/cqa_block_ca.php

[<ki...@us...>]

Revision: 113
          http://xc-tokai.svn.sourceforge.net/xc-tokai/?rev=113&view=rev
Author:   kilica
Date:     2008-01-16 05:15:16 -0800 (Wed, 16 Jan 2008)

Log Message:
-----------


Modified Paths:
--------------
    modules_cqa/trunk/blocks/cqa_block_ca.php

Modified: modules_cqa/trunk/blocks/cqa_block_ca.php
===================================================================
--- modules_cqa/trunk/blocks/cqa_block_ca.php	2008-01-16 05:49:43 UTC (rev 112)
+++ modules_cqa/trunk/blocks/cqa_block_ca.php	2008-01-16 13:15:16 UTC (rev 113)
@@ -15,7 +15,7 @@
 		$sql = "SELECT a.*, q.cat_id, q.cq_id, q.title as qtitle FROM ".$xoopsDB->prefix('cqa_ca') ." a LEFT JOIN ". $xoopsDB->prefix('cqa_cq') ." q ON q.cq_id=a.cq_id WHERE q.cat_id=". $options[1] ." ORDER BY a.ans_unixtime DESC LIMIT ". $options[0];
 	}
 	else{
-		$sql = "SELECT a.* q.cat, q.cq_id, q.title as qtitle FROM ".$xoopsDB->prefix('cqa_ca') ." a LEFT JOIN ". $xoopsDB->prefix('cqa_cq') ." q ON q.cq_id=a.cq_id ORDER BY ans_unixtime DESC LIMIT ". $options[0];
+		$sql = "SELECT a.*, q.cat_id, q.cq_id, q.title as qtitle FROM ".$xoopsDB->prefix('cqa_ca') ." a LEFT JOIN ". $xoopsDB->prefix('cqa_cq') ." q ON q.cq_id=a.cq_id ORDER BY ans_unixtime DESC LIMIT ". $options[0];
 	}
 
 	$result = $aHandler->db->query($sql);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.