I am interested in learning how to develop an open source PHP application (using mySQL) similiar to the SugarCRM (www.sugarcrm.com) application, but not for CRM.
Problem is, I've never written a line of PHP, nor have I done much coding at all. I know HTML, CSS, and can install PHP apps like no tomorrow, even modifying the code here and there...
...but this project will require me to learn PHP inside out.
Therefore, I'm wondering if any of you can point me in the right direction to get started. I'd LOVE to find a video, book, or online tutorial that would start with showing me how to create a SIMPLE php app which querries a mySQL db and returns results, or inserts data in the DB, etc... In fact, most of what I am looking to do is select, insert, and query a mySQL db for display on a web site.
Where do I start? I will add that I am patient, and willing to spend the next 6-12 months teaching myself... just in need of some good, user-friendly resources. Ideally, it would be great to find a PHP Builder tool set which helps by creating code and tying it to web objects such as radio buttons, etc... but I'm not sure this exists.
THANKS in advance for your guidance!
-NORTH