Copyright

Peachpit Press
1249 Eighth Street
Berkeley, CA 94710
510/524-2178
800/283-9444
510/524-2221 (fax)

Find us on the Web at www.peachpit.com.

To report errors, please send a note to [e-mail].

Peachpit Press is a division of Pearson Education.

Copyright © 2005 by Larry Ullman

Credits

Editor: Rebecca Gulick

Production Coordinator: Andrei Pasternak

Copyeditor: Robert Campbell

Proofreader: Alison Kelley

Compositor: Danielle Foster

Indexer: Karin Arrigoni

Cover Design: The Visual Group

Interior Design: George Mattingly / GMD

Notice of Rights

All rights reserved. No part of this book may be reproduced or transmitted in any form by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. For information on getting permission for reprints and excerpts, contact [e-mail].

Notice of Liability

The information in this book is distributed on an "As Is" basis, without warranty. While every precaution has been taken in the preparation of the book, neither the author nor Peachpit shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the instructions contained in this book or by the computer software and hardware products described in it.

Trademarks

MySQL is a registered trademark of MySQL AB in the United States and in other countries. Macintosh and Mac OS X are registered trademarks of Apple Computer, Inc. Microsoft and Windows are registered trademarks of Microsoft Corporation. Other product names used in this book may be trademarks of their own respective owners. Images of Web sites in this book are copyrighted by the original holders and are used with their kind permission. This book is not officially endorsed by nor affiliated with any of the above companies, including MySQL AB.

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and Peachpit was aware of a trademark claim, the designations appear as requested by the owner of the trademark. All other product names and services identified throughout this book are used in editorial fashion only and for the benefit of such companies with no intention of infringement of the trademark. No such use, or the use of any trade name, is intended to convey endorsement or other affiliation with this book.

9 8 7 6 5 4 3 2 1

Printed and bound in the United States of America

Dedication

Dedicated to the fine faculty at my alma mater, Northeast Missouri State University. In particular, I would like to thank: Dr. Monica Barron, Dr. Dennis Leavens, Dr. Ed Tyler, and Dr. Cole Woodcox. I would not be who I am as a writer, as a student, as a teacher, or as a person if it were not for the magnanimous, affecting, and brilliant instruction I received from these educators.

Special Thanks to

My heartfelt thanks to everyone at Peachpit Press, as always. Special mention goes out to Nancy Ruenzel, Nancy Davis, and Marjorie Baer, for their support; Andrei Pasternak, for turning files into chapters; Lisi Baldwin, for sending translated copies on to me; Whitney Walker, who edited the first edition; and the other dozen or so people at Peachpit and Pearson whose names and titles I don't know but should.

My gratitude to editor extraordinaire Rebecca Gulick, who makes my job so much easier. And thanks to Bob Campbell for his hard work, helpful suggestions, and impressive attention to detail. Thanks also to Karin Arrigoni for indexing, Alison Kelley for proofreading, and Danielle Foster for laying out the book.

Kudos to the good people working on PHP and MySQL, and a hearty "cheers" to the denizens of the various newsgroups, mailing lists, support forums, etc., who offer assistance and advice to those in need.

Thanks, as always, to the readers, whose support gives my job relevance.

Finally, I would not be able to get through a single book if it weren't for the love and support of my wife, Jessica. It's all downhill from here, I promise.