Execute("SELECT DISTINCT author FROM articles WHERE type=3 AND is_active=1 AND is_hundred_words=is_hundred_words ORDER BY author ASC"); $counter=0; while (!$authors->EOF) { $counter++; $iss=$author==$counter?'selected="selected"':''; if ($iss!='') $author_name=$authors->Fields('author').' | קצר | דעות'; $authors->MoveNext(); } $authors->Close(); unset($authors); } else { $author_name='קצר | דעות'; } } $general = $CONN->Execute("SELECT * FROM general"); ?> <?=$author_name?>
קצר
ב"ה,
Execute('SELECT * FROM cats WHERE is_articles=1 AND hidden=0'); echo '»ראשי'; while (!$cats->EOF) { if ($cats->Fields('id')==$cat) { echo '»'.$cats->Fields('name').''; $cat_name = $cats->Fields('name'); } else { echo '»'.$cats->Fields('name').''; } $cats->MoveNext(); } $cats->Close(); unset($cats); echo '»דעות'; echo '»כותרות העיתונים'; echo '»תמונות'; ?>
*/ ?>
דעות
Execute("SELECT A.*, (SELECT COUNT(*) AS total_res FROM articles_res B WHERE B.art=A.id AND B.is_active=1) AS total_res FROM articles A WHERE type=3 AND is_active=1 AND id=$load_id ORDER BY addtime_ts DESC"); } else { if ($author) { $arts = $CONN->Execute("SELECT A.*, (SELECT COUNT(*) AS total_res FROM articles_res B WHERE B.art=A.id AND B.is_active=1) AS total_res FROM articles A WHERE type=3 AND is_active=1 AND is_hundred_words=is_hundred_words AND author='$author_name' ORDER BY addtime_ts DESC LIMIT $offset,$PAGE_SIZE"); } else { $arts = $CONN->Execute("SELECT A.*, (SELECT COUNT(*) AS total_res FROM articles_res B WHERE B.art=A.id AND B.is_active=1) AS total_res FROM articles A WHERE type=3 AND is_active=1 AND is_hundred_words=is_hundred_words ORDER BY addtime_ts DESC LIMIT $offset,$PAGE_SIZE"); } } while (!$arts->EOF) { ?>
<?=htmlspecialchars($arts->Fields('author'))?>
Fields('id').');">'.$arts->Fields('title').'
'; echo ''.$arts->Fields('author').' / '; $ts = $arts->Fields('addtime_ts'); echo writeHebrewDate($ts, 0, 1); echo "\n\r / "; echo date('H:i', $ts).'
'; echo ''.$arts->Fields('total_res').' תגובות'; echo ''."\n\r".'|'."\n\r".''; ?> קישור לדעה הוסף תגובה הדפסה
'.nl2p($arts->Fields('subtitle')).'

')?>
MoveNext(); } if ($author) { $nav_prev='/דעות/כותב/'.$author.'&offset='.($offset-$PAGE_SIZE); $nav_next='/דעות/כותב/'.$author.'&offset='.($offset+$PAGE_SIZE); } else { $nav_prev='?offset='.($offset-$PAGE_SIZE); $nav_next='?offset='.($offset+$PAGE_SIZE); } ?>
0) { echo '«'."\n\r"; echo 'לדף הקודם
'; } ?>
לדף הבא
'; } ?>
Close(); unset($arts); ?>
תמונה תמונות נוספות



צילום:
ניווט מהיר: =1; $i--) { if ($i==1) { echo ''.$i.''; } else { echo ''.$i.''; } if ($i>1) { echo ''."\n\r".'|'."\n\r".''; } } ?>
שימושון
Close(); unset($general); DATABASE('close'); ?>