[id10t]

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!) ...