Royal Society Alert

Issue $issue $date_string

"; $query = "SELECT id, title, issue, status_editorial, sort_order FROM alert where status = 1 and issue = $issue order by status_editorial desc, sort_order asc, id desc"; $result = MYSQL_QUERY($query); $number = mysql_numrows($result); $i = 0; if ($result == 0): print "No science alerts available"; elseif ($number == 0) : print "No records found"; elseif ($number > 0) : print "

Jump to an item..."; print"Contents"; while ($i < $number): $newsid = mysql_result($result,$i,"id"); $issue = mysql_result($result,$i,"issue"); $title = stripslashes(mysql_result($result,$i,"title")); print"$title"; $i++; endwhile; print "

"; endif; if ($alert==""): $query = "SELECT id, title, issue, intro, status_editorial, sort_order FROM alert where status = 1 and issue = $issue order by status_editorial desc, sort_order asc, id desc"; $result = MYSQL_QUERY($query); $number = mysql_numrows($result); $i = 0; $blob = " "; if ($result == 0): print "Database Error (get news list)"; elseif ($number == 0) : print "No records found"; elseif ($number > 0) : while ($i < $number): $newsid = mysql_result($result,$i,"id"); $issue = mysql_result($result,$i,"issue"); $title = stripslashes(mysql_result($result,$i,"title")); $intro = nl2br(chop(stripslashes(mysql_result($result,$i,"intro")))); print"

$title

$intro

"; $i++; endwhile; endif; elseif ($alert!=""): $query = "SELECT * FROM alert where id=$alert"; $result = MYSQL_QUERY($query); $number = mysql_numrows($result); $i = 0; $blob = " "; if ($result == 0): print "Database Error (get news list)"; elseif ($number == 0) : print "No records found"; elseif ($number > 0) : while ($i < $number): $newsid = mysql_result($result,$i,"id"); $title = stripslashes(mysql_result($result,$i,"title")); $intro = nl2br(chop(stripslashes(mysql_result($result,$i,"intro")))); $story = nl2br(chop(stripslashes(mysql_result($result,$i,"story")))); print"

$title

$intro

$story

---

"; $i++; endwhile; endif; endif; ?>

here"; else: print "Printing? Click here"; endif; ?> Alert Archives Select an issue... "; while ($earliest <= $latest): print"Number $latest"; $latest--; endwhile; print""; ?> Want Royal Society Alerts before Number 97? Click here.