1
I added a new block to the download module, at the moment is a "latest downloads" clone block.
but i want modify to allow latest downloads by category, i know is very simple, only change a MySQL query.
but i don´t know much about mysql, them i need a little help.
Let me explain better, i will create one block x category, them i not need create code to set options from admin panel,etc.
I want show latest downloads from category 2 (cid=2)
the original query is
$result = $xoopsDB->query("SELECT lid, cid, title, date, hits FROM ".$xoopsDB->prefix("mydownloads_downloads")." WHERE status>0 ORDER BY ".$options[0]." DESC",$options[1],0);
i want modify the query to only show downloads from a specific cid (cid=2)
thanks in advance , sorry for my poor english.