\n";
$tokNum++;
}
}
echo "";
$fields[] = "body";
$fields[] = "subject";
$fields[] = "author";
if($id==0){
$SQL = "select $TableName.id, $TableName.thread, author, subject, datestamp, body from $TableName, $BodiesTable where $TableName.id = $BodiesTable.id and (";
}
elseif($action=1){
$SQL = "select $TableName.id, $TableName.thread, author, subject, datestamp, body from $TableName, $BodiesTable where $TableName.id<$id and $TableName.id = $BodiesTable.id and (";
}
for($i=0; $itype=="postgresql"){
$limit="";
}
else{
$limit=" limit 20";
}
$SQL .= " order by id desc".$limit;
echo "\n\n";
$q->query($DB, $SQL);
$rows = $q->numrows();
}
$sTitle=" search";
if(file_exists("header_$TableName.inc")){
include "./header_$TableName.inc";
}
else{
include "./header.inc";
}
?>
valign="TOP" nowrap> |
>
0){
$message = $q->getrow();
$x=$start_num;
While(is_array($message)){
$x++;
if(!isset($top_id)){
$top_id=$message["id"];
}
echo "- $x. ".chop($message["subject"])." - ".chop($message["author"])."
\n - ";
echo ereg_replace("<([^>]*)>", "\\1", chop(substr($message["body"], 0, 200)))."
";
echo "$lDate: ".date_format($message["datestamp"])." \n";
echo "
\n";
$last_id=$message["id"];
$message = $q->getrow();
}
}
else{
echo $lNoMatches;
}
?>
|