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 "| Title | "; echo "Author | "; echo "Genre | "; echo "Start-End | "; echo "Pages | "; echo "Recommendation | "; echo "".$row[1]." | "; echo "".getAuthorList($row[0])." | "; echo "".$row[3]." | "; echo "".$row[4]." - ".$row[5]." | "; echo "".$row[6]." | "; echo "".showStars($row[7])." | "; echo "\n"; } } else { echo "\n
|---|---|---|---|---|---|
| sql error ".mysql_error()." \n | |||||