Displaying Recent Readings for default user. When the site is live, this will show your recent readings.

\n"; } $sql="SELECT r.work_id, t.full_title, w.genre_cd, g.genre_nm, r.start_dt, r.end_dt, r.pages, r.recommendation FROM Reading r, Work w, Title t, Genre g WHERE r.work_id = w.work_id and w.title_id = t.title_id and w.genre_cd = g.genre_cd ORDER BY r.end_dt desc LIMIT 50"; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; if ($result=mysql_query($sql,$link)) { while ($row=mysql_fetch_row($result)) { hRowColor(); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; } } else { echo "\n\n"; } echo "

Title	Author	Genre	Start-End	Pages	Recommendation
".$row[1]."	".getAuthorList($row[0])."	".$row[3]."	".$row[4]." - ".$row[5]."	".$row[6]."	".showStars($row[7])."
sql error ".mysql_error()." \n

"; displayFoot(); ?>