specializing in digital media technologies

Unfortunately, despite the best efforts of myself, the technical editor, the copy editor, and the line editor, despite the multiple revisions, errors still occur. This page lists all the errors found in the book.

Note: errors are corrected in subsequent printings and therefore your particular copy may not contain all of the following.

You may also find the solution to your problem by using the book's corresponding forum. Signficant changes in the technology will be addressed there and you can also find problems and solutions encountered by other readers.

Known Errors in the Book:

Chapter	Page #	Description	Date Added
1: Introduction to PHP	6	The first word in the last paragraph in the sidebar should be "An" not "As".	February 18, 2008
1: Introduction to PHP	14	In the second bullet point, it should say that a variable's name can contain a combination of letters, numbers, and the underscore.	February 18, 2008
1: Introduction to PHP	28	In the code in Step 2, an apostrophe is missing. The code should be: define ('TODAY', 'August 28, 2007'); The code in the corresponding script is correct.	January 26, 2008
1: Introduction to PHP	30	On line five, it should say ...examples used so far....	May 19, 2008
2: Programming with PHP	34	In the URL in the sidebar, there's an extraneous space between "script." and "php?".	February 18, 2008
2: Programming with PHP	61	The last line of code in the right-hand column should refer to "Primes" plural: {$numbers['Primes'][0]}.	May 19, 2008
2: Programming with PHP	65	The last paragraph of the sidebar should refer to the $s2 variable, not $string2.	February 18, 2008
3: Creating Dynamic Web Sites	85	In the paragraph under Step 2, the last sentence should start This variable will correlate....	July 09, 2008
3: Creating Dynamic Web Sites	89	In the code at the end of the left-hand column, there's an extra closing parentheses after ($gender == 'F').	January 26, 2008
3: Creating Dynamic Web Sites	89	In the right-hand column, the second word of the second paragraph (not including the code) should be "here", not "hear".	January 26, 2008
3: Creating Dynamic Web Sites	89	In the second block of example code in the right-hand column, the third line is missing a closing double quotation mark. It should be echo "<option value=\"$y\"";	January 19, 2009
3: Creating Dynamic Web Sites	98	The last paragraph before the numbered steps should say there's no way to pass $msg a value.	April 15, 2008
4: Introduction to MySQL	118	There should not be a space between the hyphen and the letter "u" in the first bullet.	May 19, 2008
5: Introduction to SQL	137	The SQL command in the second tip should end with WHERE last_name LIKE '_smith%'.	February 18, 2008
5: Introduction to SQL	146	The last sentence of the first paragraph should read ...MySQL functions in other types....	July 09, 2008
5: Introduction to SQL	147	In Table 5.2, the Usage value for the second item should begin as "CONCAT_WS(...".	February 18, 2008
5: Introduction to SQL	147	In Table 5.2, the Returns value for the last item should say that the string indexing begins at 1, not 0.	February 18, 2008
6: Advanced SQL and MySQL	170	The > on the third line of the SQL command should not be there This should instead be an indentation of the previous line, indicating a continuation.	May 24, 2009
6: Advanced SQL and MySQL	172	In the third sentence in the right-hand paragraph, "troutocity" should be "troutster".	October 25, 2008
6: Advanced SQL and MySQL	179	The last sentence in Step 2 should say that "An outer join is used...".	February 18, 2008
6: Advanced SQL and MySQL	179	The query in Step 2 should actually end GROUP BY (users.user_id). As written in the book, only one user without posts will be returned. The same change applies to Figure 6.24.	November 05, 2008
6: Advanced SQL and MySQL	182	In the second paragraph in the right-hand column, "doesn't not" should just be "does not".	October 25, 2008
6: Advanced SQL and MySQL	185	In the first block of example code in the right-hand column, the second colum1name should be column2name.	February 14, 2009
7: Error Handling and Debugging	207	The code in Step 1 omits the <h2>Testing Display Errors</h2> that is in the corresponding script.	April 15, 2008
8: Using PHP with MySQL	224	In Script 8.1, the opening HEAD tag on line 3 erroneously has a quotation mark.	July 09, 2008
8: Using PHP with MySQL	236	The first line of code in Step 9 should read mysqli_close($dbc);. The corresponding script is correct.	April 15, 2008
8: Using PHP with MySQL	236	There's an extraneous >> in the fourth line of code under step 10. The corresponding script is correct.	May 24, 2009
8: Using PHP with MySQL	237	Not a huge deal, but in a couple of places, the email input in the HTML form has a maxlength of 80, whereas the defined column in the database has a maximum length of 60.	November 01, 2009
8: Using PHP with MySQL	252	Line 18 of Script 8.7 should begin with $e = .... The corresponding code in Step 4 on page 253 is correct.	January 26, 2008
9: Common Programming Techniques	266	The header in Figure 9.3 should be "Delete a User".	May 19, 2008
9: Common Programming Techniques	275	The first line of code under Step 12 should refer to MYSQLI_NUM (all in uppercase). The corresponding script is correct.	April 15, 2008
9: Common Programming Techniques	280	The comment in the last line of code in Step 5 should say that it's the end of the "p" IF. The corresponding code in the script is correct.	February 14, 2009
9: Common Programming Techniques	281	On lines 9 and 10 of the first paragraph under step 6, it should say The second page would show records 10 through 19; the third, 20 through 29; and so forth.	May 19, 2008
10: Web Application Development	309	Line 24 of Script 10.3 inadvertently include 'image/jpeg' twice. This also applies to the code in Step 3 on page 310.	April 15, 2008
10: Web Application Development	311	The echo statement in Step 5 should just read echo '<p class="error">Please upload a JPEG or PNG image.</p>'; . The code in the corresponding script is correct.	April 15, 2008
10: Web Application Development	312	The MAX_FILE_SIZE hidden input in Script 10.3 on line 85 should end with a space and a slash to be XHTML compliant. This also applies to the code in Step 10 on page 314.	October 25, 2008
10: Web Application Development	324	The second-to-last line of text should refer to the $name variable not the $name function.	April 15, 2008
11: Cookies and Sessions	357	In the paragraph that begins Another change you..., the word "the" is repeated.	April 15, 2008
11: Cookies and Sessions	359	Line 9 of Script 11.13 and the corresponding code in Step 5 needs one more closing parentheses.	February 18, 2008
12: Security Methods	369	On the fourth line of the sidebar, "even form a database" should be "even from a database".	October 25, 2008
12: Security Methods	383	In line 13 of the first paragraph, it should say "...view the data in its...".	January 19, 2009
13: Perl-compatible Regular Expressions	392	The two uses of print in Step 5 should actually be echo, to match the code in Script 13.1.	November 01, 2009
Introduction	393	The first line of code under step 6 should be a closing curly brace, as found on line 29 of Script 13.1	May 24, 2009
13: Perl-compatible Regular Expressions	397	There should not be a space between the comma and the y in the fifth entry of Table 13.2.	November 01, 2009
13: Perl-compatible Regular Expressions	411	The second sentence in the caption to Figure 13.24 does not apply to the image and should be deleted.	November 01, 2009
14: Making Universal Sites	430	When creating or altering tables, you should declare the collation using the keyword COLLATE, not COLLATION.	November 01, 2009
14: Making Universal Sites	437	In the sidebar, the three references to the set_locale() function should be setlocale(), without an underscore. The same goes for ucwords(), in the right-hand column.	October 25, 2008
15: Example--Message Board	478	Line 41 of Script 15.7 should refer to $_SESSION['lid'] instead of $lid. The change also applies to the corresponding code in Step 6 on page 479.	November 01, 2009
16: Example--User Registration	491	Line 21 of Script 16.3 should end with a slash after www.example.com.	July 09, 2008
16: Example--User Registration	492	Line 50 of Script 16.3 should begin echo '<div class="error">'.	November 01, 2009
16: Example--User Registration	509	On line 13 of Script 16.7, and on line 8 of the code in Step 2, there's a closing parentheses missing. The correct line should be if (isset($_GET['y']) && (strlen($_GET['y']) == 32) ) {	January 26, 2008
16: Example--User Registration	510	Line 29 of Script 16.7 and the corresponding code in Step 4 on page 511 should not have the closing </font> tag.	October 25, 2008
16: Example--User Registration	523	The last sentence in the explanation for Step 7 should say "email address" instead of "password" (twice).	October 25, 2008
16: Example--User Registration	528	The first sentence in the second paragraph of the sidebar should say that the footer file creates the links.	November 01, 2009
17: Example--E-Commerce	542	Lines 163 and 182 of Script 17.1, and the corresponding code under Step 16 on page 549 and Step 18 on page 551, are missing the space before /> to make the page XHTML compliant.	November 01, 2009
16: Example--User Registration	555	The code in step 5 is actually a repetition of the last two lines of code in step 4.	May 19, 2008
17: Example--E-Commerce	582	Line 55 of Script 17.10 should not be commented out. The code in the corresponding steps is correct.	February 14, 2009
Click here to view the errata in the order they were submitted. Click here to view the most recent errors first. Click here to view the errata by page number.

Submit an Error:

Please limit submitted errors to grammatical, factual, or technical problems found within the PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide (3rd Edition) text itself. Please do not use this form for subjective suggestions or to ask questions. You will not necessarily receive a reply based upon any information submitted through this form! I may reply, depending upon the situation, but if you need a reply, do not use this form.

If you are experiencing problems getting something to work, please DO NOT use this form. Either use the forum for a faster reply or contact the author directly (although it could be a week or more before you see a reply).

Chapter	Introduction Ch 1: Introduction to PHP Ch 2: Programming with PHP Ch 3: Creating Dynamic Web Sites Ch 4: Introduction to MySQL Ch 5: Introduction to SQL Ch 6: Advanced SQL and MySQL Ch 7: Error Handling and Debugging Ch 8: Using PHP with MySQL Ch 9: Common Programming Techniques Ch 10: Web Application Development Ch 11: Cookies and Sessions Ch 12: Security Methods Ch 13: Perl-compatible Regular Expressions Ch 14: Making Universal Sites Ch 15: Example--Message Board Ch 16: Example--User Registration Ch 17: Example--E-Commerce Ap A: Installation
Page #
Book Error
Your Name
Your Email Address

Newsletter #25 Sent!

The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.
(February 2, 2010)

Newsletter #24 Released

The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.
(December 17, 2009)

New Blog Series on the Yii Framework

I've been writing a series of articles on the Yii framework for PHP Web development. There are currently seven posts, taking you from start to finish of the development process, with more to come.
(November 12, 2009)

more news...