NOW()-INTERVAL $interval HOUR and nodes.node_system_access='public' and nodes.node_vector like '$vector%' GROUP BY I.node_id ORDER BY count desc"; $set=$db->query($q); while ($set->next()) { $k_array[]=$set->getRecord(); } $smarty->assign('get_temp_k',$k_array); } ?>