id = 1; echo ""; if (!$hid) { $x = db_query("select id,date,header.from from header where uid=$user->id order by id"); if (mysql_num_rows($x)>=1) { echo ""; echo ""; while($r = mysql_fetch_object($x)) { echo ""; } echo "
Msg IDDateFrom
$r->id  $r->date   $r->from
"; } } else { // find next and previous $x = db_query("select id from header where uid=$user->id and id>$hid order by id asc limit 1"); $next = mysql_fetch_object($x); $x = db_query("select id from header where uid=$user->id and id<$hid order by id desc limit 1"); $previous = mysql_fetch_object($x); $x = db_query("select id,bid,date,header.from,text from header where id=$hid and uid=$user->id order by header.from,date"); if (mysql_num_rows($x)==1) { $r = mysql_fetch_object($x); $y = db_query("select id,body from body where id=$r->bid"); if (mysql_num_rows($y)==1) $s = mysql_fetch_object($y); else die("Error, can't find that body."); } else die("Error, can't find that header."); print "
Message ID $r->id
From $r->from $r->date
<-- previous | index | next -->
"; print "
$r->text
$s->body
"; }