First Time - Building a database, a learning project

[SeanDempsey]

I am beginning to learn PHP, and I have found it to be very interesting and fun. Until, I have only edited and modified packages like WordPress or CS-Cart/OSCommerce, but I would like to start making my own stuff from scratch, so I am starting a project, but I have no idea how to begin.

Here is what I want to end up with: A page that displays a list of (in this case) video games, sorted with the newest release date at the top. The game titles would click to a website (amazon, whatever).

The admin would allow me to enter the game title, select the system, and enter a release date. I'd want to be able to list the games in the admin and edit them individually.

Also, the scary part (for me) is that I want to enter the games and the system in the admin, and have the main page only display one type of system at a time, and the user selects which system he wants to see, and it repopulates the list on a refresh.

This really is just a database list, I Am sure that you guys have made this sort of thing countless times. But to me, this is all new. I am hoping that by doing this project, I'll learn alot.

I have the latest Php and SQL on my server, all running fine.

Any help, links, tutorials, or just advice would be appreciated. Thanks

[Drumminxx]

get this book its great and easy to understand. I have an older version but this newer one should be just as good if not better.

[a href=\"http://www.amazon.com/exec/obidos/tg/detail/-/0321336577/qid=1151210165/sr=8-1/ref=sr_8_1/103-1155768-2811805?v=glance&n=507846\" target=\"_blank\"]Larry Ullman, PHP and MySQL for Dynamic Websites[/a]

its also great to keep around for a reference

[Barand]

A series of articles by Kevin Yank started me off with PHP/MySQL

[a href=\"http://www.sitepoint.com/article/publishing-mysql-data-web\" target=\"_blank\"]http://www.sitepoint.com/article/publishing-mysql-data-web[/a]