At least three people tested this code: Nicholas, the tech editor, and myself. It worked two years ago. It was developed using PHP 4 and MySQL 3.
Thanks for posting this without even asking if the problem was solved.
PHP 4.4.9 (fresh install)
MySQL 5.1 (fresh install and used OLD_PASSWORD() to work with PHP 4)
Any other problems you're having with the application lies within your environment.
I will NOT purchase another book by these people!
I'm sorry to hear that. We strive to provide up-to-date information and code examples. But alas, we cannot please everyone.