Plagiarist Poetry Sites: Plagiarist.com | Poetry X | Poetry Discussion Forums | Open Poetry Project | Joycean.org

if ($action == 'new') { // Check to see if an author has been added in the past month print ("

Newly Added:

"); print ("

The following poems have been added in the past month.

"); if (!$more) { $more = "0"; } $recent_works = mysql_query ("SELECT date_added,wid,aid,title FROM Works ORDER BY date_added DESC LIMIT $more,50", $cnx); while ($row = mysql_fetch_array($recent_works)) { $newly_work = $row['date_added']; $today = date(Y-m-d); $wid = $row['wid']; $aid = $row['aid']; $work = $row['title']; $auths = mysql_query ("SELECT first_name,middle_name,last_name FROM Authors WHERE aid = '$aid' ", $cnx); while ($auths_row = mysql_fetch_array($auths)) { $authors = "$auths_row[first_name] "; if ($auths_row[middle_name] !="") { $authors .= "$auths_row[middle_name] "; } $authors .= "$auths_row[last_name]"; if((strtotime($today) - strtotime($newly_work)) < 2419200) { print ("\"$work\" by $authors
"); } } } print ("

"); if ($more !=0) { $prevmore = $more-50; print ("« Previous 50"); } if((strtotime($today) - strtotime($newly_work)) < 2419200) { $newmore = $more+50; print ("Next 50 »"); } print (""); }