What's New

$result = db_query_range(db_rewrite_sql(“SELECT n.nid, n.title, n.created, f.filepath AS filepath, nt.teaser AS teaser FROM node n, term_node tn, content_field_front_preview cffp, files f, nodeteaser nt WHERE n.type = ‘news’ AND n.status = 1 AND n.nid = tn.nid AND tn.tid = 12 AND cffp.nid = n.nid AND cffp.field_front_preview_fid = f.fid AND nt.nid = n.nid ORDER BY n.created DESC”),0,2);

while ($news = db_fetch_object($result)) {
?>

}
?>

 

$result = db_query_range(db_rewrite_sql(“SELECT n.nid, n.title, n.created, f.filepath AS filepath, nt.teaser AS teaser FROM node n, term_node tn, content_field_front_preview cffp, files f, nodeteaser nt WHERE n.type = ‘news’ AND n.status = 1 AND n.nid = tn.nid AND tn.tid = 13 AND cffp.nid = n.nid AND cffp.field_front_preview_fid = f.fid AND nt.nid = n.nid ORDER BY n.created DESC”),0,2);

while ($news = db_fetch_object($result)) {
?>

}
?>

 

$result = db_query_range(db_rewrite_sql(“SELECT n.nid, n.title, n.created, f.filepath AS filepath, nt.teaser AS teaser FROM node n, term_node tn, content_field_front_preview cffp, files f, nodeteaser nt WHERE n.type = ‘news’ AND n.status = 1 AND n.nid = tn.nid AND tn.tid = 14 AND cffp.nid = n.nid AND cffp.field_front_preview_fid = f.fid AND nt.nid = n.nid ORDER BY n.created DESC”),0,2);

while ($news = db_fetch_object($result)) {
?>

}
?>

 

$result = db_query_range(db_rewrite_sql(“SELECT n.nid, n.title, n.created, f.filepath AS filepath, nt.teaser AS teaser FROM node n, term_node tn, content_field_front_preview cffp, files f, nodeteaser nt WHERE n.type = ‘news’ AND n.status = 1 AND n.nid = tn.nid AND tn.tid = 15 AND cffp.nid = n.nid AND cffp.field_front_preview_fid = f.fid AND nt.nid = n.nid ORDER BY n.created DESC”),0,2);

while ($news = db_fetch_object($result)) {
?>

}
?>

 

$result = db_query_range(db_rewrite_sql(“SELECT n.nid, n.title, n.created, f.filepath AS filepath, nt.teaser AS teaser FROM node n, term_node tn, content_field_front_preview cffp, files f, nodeteaser nt WHERE n.type = ‘news’ AND n.status = 1 AND n.nid = tn.nid AND tn.tid = 16 AND cffp.nid = n.nid AND cffp.field_front_preview_fid = f.fid AND nt.nid = n.nid ORDER BY n.created DESC”),0,2);

while ($news = db_fetch_object($result)) {
?>

}
?>

 

$result = db_query_range(db_rewrite_sql(“SELECT n.nid, n.title, n.created, f.filepath AS filepath, nt.teaser AS teaser FROM node n, term_node tn, content_field_front_preview cffp, files f, nodeteaser nt WHERE n.type = ‘news’ AND n.status = 1 AND n.nid = tn.nid AND tn.tid = 17 AND cffp.nid = n.nid AND cffp.field_front_preview_fid = f.fid AND nt.nid = n.nid ORDER BY n.created DESC”),0,2);

while ($news = db_fetch_object($result)) {
?>

}
?>