Reddit mentions of Beginning PHP and MySQL: From Novice to Professional

PHP and MySQL Web Development (4th Edition)

Beginning PHP and MySQL: From Novice to Professional

Read the second book, do all the examples, then go back to the first book. Pay a lot of attention toward array manipulation. When you're comfortable with that, get into OOP. Once you do and OOP clicks for you, you'll be able to go to town on anything. I've heard a lot of good about Jefferey Way's video lesson courses over at TutsPlus. I've never used them nor do I need to, but I've never heard a single bad thing about their video courses. Their Javascript and Jquery is a great starting point. This is great stuff too if you're willing to put in the time.

Professional JavaScript for Web Developers

JavaScript: The Definitive Guide: Activate Your Web Pages

Responsive Web Design with HTML5 and CSS3

The Node Beginner Book
Professional Node.js: Building Javascript Based Scalable Software

Paid online "schooling":

http://teamtreehouse.com/

http://www.codeschool.com/

Bonus:

http://hackdesign.org/


I've got a shit ton (Excuse my French) of books in print and E-Format that I could recommend, but it would span a couple pages. Anything is easy to learn so as long is it's served in a hierarchical format that makes it easy to absorb the information. A year ago I started to learn Ruby and using ROR as a framework. I can say it's been quite fun and I feel confident that I could write a fully complete web app using it. I started node.JS a few months ago, but it's been on break due to being sick and some unexpected events.

My knowledge is extensive only because I wanted it to be. I'm not gifted by any means nor am I special. Not by a longshot. Some people are gifted when it comes to dev and design, most are not. Most only know one or the other. I forced myself to learn and be good at both. I'm 23, I started when I was about 12. I'm only breathing more comfortably now. I know a load of people on here and other sites who make me look like complete shit.


Also for what it's worth, sign up to StackOverflow. It's the bible and holy grail rolled up into one site. It's amazing.

Relational DB Design - Here's a quick "MySQL Database Design Tutorial" result from Google.

Beginning PHP & MySQL - Here's a well rated book from Amazon. I've enjoyed the Apress books I've gotten in the past, and this one seems well reviewed. I assume, building a website, you are going to start with MySQL and PHP. I could be wrong in this assumption, and if so check out other Beginning and Introductory Database books for something more appropriate to your chosen starting point.

A look through Wikipedia Database Normalization would also be enlightening (with some interesting external links at the bottom for further learning as well).

The goal of database normalization is to remove duplication... so you'd have your "Person" table, with Person# (Unique ID of sorts), LName, FName, MI, etc.

Then you'd have your "Quotes" table: Person#, Quote#, Quote. Each Person# and Quote# is a unique combination that identifies the person and quote.

Add other tables for Video Links (Person#, Link#, Link, Description, etc), Snippets (Person#, Snippet#, Snippet)... etc.

The goal is such that when you update a persons Name (Sally gets married or corrects a typo in her name), you don't have to update every table.

Thanks for the offer :) I may send you a message in the next week or so. I bought a couple books on PHP and Mysql (this one and this one) to get myself up to speed. I've got about 3 weeks to get this application hammered out :/