";
print "Welcome, ".$w[full_name];
print "
Back to the previous page:
";
$sql = "select * from tbl_mediarel where writer = '$auth_user' ".
"order by created desc";
$result = pg_exec($conn, $sql);
$numrows = pg_numrows($result);
print "There are ";
print $numrows;
print " mediareleases: ";
print "
Add new";
print "
";
if (pg_numrows($result)) {
print "
| Headline | Page | "; print "Created | Last modified | Publish Date |
|---|---|---|---|---|
| "; print $qry[headline]; print " | "; print ""; print $qry[page]; print " | "; print ""; print date("M d, Y, H:i", $qry[created]); print " | "; print ""; print date("M d, Y, H:i", $qry[modified]); print " | "; print ""; if ($qry[published]) print date("M d, Y, H:i", $qry[published]); else { print "[edit] "; print "[delete] "; //print "[keywords]"; } print " | "; print "