تالار گفتمان nCIS.ir

 $query = array();
foreach($categoryIds as $cid) {
$query[] = 'SELECT
    n.id           AS nid,
    n.cat_id       AS ncat_id,
    n.owner_id     AS nowner_id,
    n.title        AS ntitle,
    n.description  AS ndescrition,
    n.keywords     AS nkeywords,
    n.visit        AS nvisit,
    n.like         AS nlike,
    n.dislike      AS ndislike,
    n.picture      AS npicture,
    n.create_date  AS ncreate_date,
    n.public_date  AS npublic_date,
    n.update_date  AS nupdate_date,
    n.expire_date  AS nexpire_date,
    n.status       AS nstatus,
    nc.id          AS ncid,
    nc.parent_id   AS ncparent_id,
    nc.owner_id    AS ncowner_id,
    nc.name        AS ncname,
    nc.title       AS nctitle,
    nc.description AS ncdescription,
    nc.picture     AS ncpicture,
    nc.create_date AS nccreate_date,
    nc.public_date AS ncpublic_date,
    nc.update_date AS ncupdate_date,
    nc.expire_date AS ncexpire_date,
    nc.status      AS ncstatus
    FROM news n
    LEFT OUTER JOIN news_categories nc
    ON nc.id = n.cat_id
    WHERE (n.cat_id = ' . Database::Escape($cid) . ') ORDER BY n.id LIMIT 0,3
    ';