Execute("SELECT * FROM tribune_current"); $row1 = $res1->fields; $res = $db->Execute("SELECT * FROM tribune WHERE id='$row1[edition]'"); $row = $res->fields; $id=$row[id]; $idprev = $row[id]-1; $idnext = $row[id]+1; } else { $res = $db->Execute("SELECT * FROM tribune WHERE id='$id'"); $row = $res->fields; $idprev = $id-1; $idnext = $id+1; } $res2 = $db->Execute("SELECT COUNT(*) AS num_ed FROM tribune"); $num = $res2->fields; $message = str_replace("\n", '
', $row[message]); ?> Tribune
ISSUE - STARDATE "1") {?>"> "1") {?>">PREVIOUS EDITION - ">NEXT EDITION ">




Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='1'"); $count1 = $count1->fields; if($count1[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='1'"); while(!$res->EOF) { $row1=$res->fields; echo " $row1[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='2'"); $count2 = $count2->fields; if($count2[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='2'"); while(!$res->EOF) { $row2=$res->fields; echo " $row2[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='3'"); $count3 = $count3->fields; if($count3[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='3'"); while(!$res->EOF) { $row3=$res->fields; echo " $row3[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='4'"); $count4 = $count4->fields; if($count4[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='4'"); while(!$res->EOF) { $row4=$res->fields; echo " $row4[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='5'"); $count5 = $count5->fields; if($count5[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='5'"); while(!$res->EOF) { $row5=$res->fields; echo " $row5[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='6'"); $count6 = $count6->fields; if($count6[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='6'"); while(!$res->EOF) { $row6=$res->fields; echo " $row6[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='7'"); $count7 = $count7->fields; if($count7[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='7'"); while(!$res->EOF) { $row7=$res->fields; echo " $row7[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>

Execute("SELECT COUNT(*) AS count FROM tribune_articles WHERE edition='$row[edition]' AND section='8'"); $count8 = $count8->fields; if($count8[count] > 0) { $res = $db->Execute("SELECT id,title FROM tribune_articles WHERE edition='$row[edition]' AND section='8'"); while(!$res->EOF) { $row8=$res->fields; echo " $row8[title]
"; $res->MoveNext(); } } else { echo "

No articles available
"; } ?>