1. The game list (e.g. click N64 then click M) no longer has the thumbnails and details, so the real estate could be used better, maybe. Perhaps a 2 column list. Also, why even bother paging? Or increase the page size a lot. No need to make people page when you could list 30 or more games on a single screen without really increasing the download weight.
Good point, I'll bump this up from 15 to 20 or 30 and see what it does to the layout. Those game list pages are the one page I am not happy with at all. I am planning on finding a way to add additional information about the games. Suggestions are definitely welcome. You guys are in a much better position to say "Hey, do this to make our life easier" as I am too "close" to the design, layout, and coding.
2. Make the breadcrumbs clickable. I was looking at Mortal Kombat 4 for N64 and the breadcrumbs correctly said N64 > M but I couldn't navigate back easily without just using the back button.
Sounds good. An easy tweak that was actually something I had considered before, but wasn't sure if anyone would attempt to use it like that.
3. Mortal Kombat 4 is in the db as Mortal Kombar 4 
Doh. I had to manually type in lots of data this week. My fingers hurt.
4. It is a bit weird that the only place you can see the number of covers for a system is the "Newest Covers" screen. Actually, the Newest Covers screen may or may not be the bext "home page" for each system. What are the plans for expanding the site? E.g. should each system have its own home page with easy access to the covers, but also access to things like guides for making the covers for that system?
I am working on another place to put this. The "home page" is kind of a tricky thing to handle with the question being, when a user clicks a category what are they trying to see? With regards to expansion and guides, we are going to have a guides section just for that, but it might work just as well to duplicate that data on the "home page" along with details about where to buy the covers for that category and what dimensions the cover images are. Thoughts?
5. The # (titles starting with numbers) link has a "9" in the breadcrumb rather than a #.
Thanks. I'll fix that.
6. It would be nice to see "Date Added" on the list of newest covers. Speaking of which, is that list correct for N64? they all just happen to be at the end of the alphabet? Or did something get messed up there?
The old database structure had a table for authors and one for covers. The new design has a games, covers, manuals, and artists table. Migrating the data meaned I had to reinsert most of the covers manually and I did them by platform so it's just the order I happened to re-insert them when I moved the data.
PS: Same on you for using SELECT * :p
I am actually rewriting all the queries to only pull the exact data that I need so it's a little speedier.
P.S. How did you know I ran a select * query?
