I have been working on a website where one of the requirements is a JavaScript slideshow and/or an image gallery that the website owner or client could update. It is possible to do this via content management systems like Wordpress or Perch (and many others) but in this case, for various reasons, we had an HTML website, without database, to work with. At the same time, the system had to be really simple. So simple in fact, that all the client has to do is upload images (via FTP perhaps) into the correct folder on the server.
One book that I pick up on a regular basis when I am in database development mode is SAMS Teach Yourself SQL. It claims to be able to give you all the SQL skills you need in 10 minutes. Whilst that may not be quite true, I find that the book is really useful as a quick refresher when I have not been database querying for some time.
OK. It's a beginners book but the simplicity and readability of the book means that is is easy to find information about SQL syntax just when you need it, whether it is a simple table join or working with database views.
I have other, perhaps more comprehensive, books about databases and SQL, but for usability and getting the job done, SAMS Teach Yourself SQL is tough to beat in my opinion.
This book was one of the books that inspired me to learn PHP and MySQL and it’s a great resource for learning how to build a database-driven website.
Macromedia Dreamweaver is used by many people to edit their standard HTML websites but it can also be used to develop PHP websites where information is pulled from a MySQL database….
Flexible Web Design by Zoe Mickley Gillenwater describes how to build fluid and elastic CSS layouts. It's a great read!
Buy from Amazon.com · Amazon.co.uk
Join SugarSync for online backup. Sync your files between Mac, PC and mobile phone. Get 2 GB FREE and up to 10 GB bonus space!