Using PHP4,MySQL
I select an author from a table which has a unique key of ISBN. The author column is indexed, and the results show all the books by that author
Select * from books where author=$somename
How do I make a link on that page that would take me to a similar book listing for the previous alphabetic author (and next author should be doable if I know how to do previous)
Table columns: author title ISBN
I know I could make a table with authors and use a unique AuthorID, but then I'd have to rebuild that table everytime we added a new book and author to the main table?
Table is large (65,000) or so, so I'd rather not do a complete new query
I select an author from a table which has a unique key of ISBN. The author column is indexed, and the results show all the books by that author
Select * from books where author=$somename
How do I make a link on that page that would take me to a similar book listing for the previous alphabetic author (and next author should be doable if I know how to do previous)
Table columns: author title ISBN
I know I could make a table with authors and use a unique AuthorID, but then I'd have to rebuild that table everytime we added a new book and author to the main table?
Table is large (65,000) or so, so I'd rather not do a complete new query