\n";
$result=doquery("select movie.id as movieid, movie.title, date_format(movie.insertdate,\"".$config["dateformat"]."\") as insertdate, concat(u.fname, \" \", u.lname) as name, u.id as userid from movie, user u, user u2 where movie.insertdate > u2.lastcheck and movie.userid = u.id and u2.id = ".intval($_COOKIE["userid"])." and u.id != ".intval($_COOKIE["userid"])." order by u.fname, movie.title");
$rowcount=mysql_num_rows($result);
if ($rowcount==0) {
$output.="There have been no new movies entered since you last checked.\n";
} else {
if ($rowcount==1) {
$output.="Since your last visit there has been just 1 new movie added: (Click here to clear this list.)\n";
} else {
$output.="Since your last visit there have been ".$rowcount." new movies added: (Click here to clear this list.)\n";
}
$output.="\n";
$lastname="";
$rows="";
while ($row=mysql_fetch_assoc($result)) {
if ($lastname==$row["name"]) {
$rows.=tr(td().td(""".htmlspecialchars($row["title"])."" on ".$row["insertdate"]));
} else {
if (!saneempty($lastname)) {
$rows.=tr(td().td());
}
$rows.=tr(td("".$row["name"]." added ").td(""".htmlspecialchars($row["title"])."" on ".$row["insertdate"]));
}
$lastname=$row["name"];
}
$output.=table($rows,0,1,0);
}
$content["body"] =& $output;
dopage($content);
?>