speaking of php programming...
 

Any recommendations on a book or books to be used as a general reference text book for teaching a PHP+SQL class?

I may be teaching such a beast in the near future, and while I have plenty of good online resources the Powers That Be decree that a printed text must be listed ... so I'd like something that would be a good reference to have and keep, not cost the student an arm and a leg.

Also, recommendations for windows and mac text editors w/ syntax highlighting, etc. - I do all my development in either kate or joe (hey, at least its not vi!) ...

For the Mac text editor I use BBedit, free version is TextWrangler, both from BareBones.

TextMate is pretty well the editor of choice for just about all programming languages for my devs (we all work on OSX). While we don't do PHP, we do front-end (html, css, etc), Ruby on Rails, Java, shell, Python, etc.

Personally, I use UltraEdit when I need a text editor, especially now that it's got native versions for Windows, Mac OSX, and Linux.

Mac Text Editor | UltraEdit for Mac