23
i get 2 errors
mysql debug block1
SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE cid IN (9,Array) ORDER BY date DESC LIMIT 0, 10
Error number: 1054
Error message: Unknown column 'Array' in 'where clause'
mysql debug block2
SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE cid IN (9,Array) ORDER BY date DESC LIMIT 0, 10
Error number: 1054
Error message: Unknown column 'Array' in 'where clause'
No matter what number i put in $sel_category= in block2,
it always take the number of the other file (9)
code:
$sel_category = 9;
include_once (XOOPS_ROOT_PATH."/class/xoopstree.php");
$xt = new XoopsTree('xoops_mydownloads_cat', "cid", "pid");
$categories = $xt->getAllChildId($sel_category);
$categorystring = implode(',', $categories);
$categorystring = $sel_category.",".$categories;
$result = $xoopsDB->query("SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE cid IN ($categorystring) ORDER BY {$options[0]} DESC", $options[1], 0);