PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- $tb = $db->query("SELECT `name` FROM category WHERE `parentid` =26");
- $th = $db->query("SELECT count(*) AS id FROM post WHERE `category` IN (SELECT id FROM category WHERE parentid=26)");
- while ($_row = $db->get_row($th )) {
- while ($rowb = $db->get_row($tb, $th)) {
- $tplb->set ( '{name}', $rowb['name'] );
- $tplb->set( '{news}', $_row['id'] );
- $tplb->compile ( 'Spisok_kat' );
- }
- }