specializing in digital media technologies

Digital Media and Communications Insights, Inc.


PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (1st Edition)-->Errata

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 18 The URL for the PHP Coding Standard, as listed in the second tip, has changed to http://alltasks.net/code/php_coding_standard.html. July 05, 2003
1: Introduction to PHP 25 In Script 1.9 on line 23, it should read ...<b>$', $price, '</b>...'. This also applies to Step 5. October 04, 2003
1: Introduction to PHP 31 On lines 23 and 26 of Script 1.11, there is an extraneous \ before the $quantity variable. The corresponding steps (2 on page 31 and 4 on page 32) are correct. June 20, 2003
2: Programming with PHP 36 On line 24 of Script 2.1 and in Step 3, there's an extra 'e' in Between. July 31, 2004
2: Programming with PHP 38 In the third line of the first paragraph, the word in italics should be handling. August 04, 2003
2: Programming with PHP 38 The echo statement on line 11 of Script 2.2, and in Step 2 on page 39, should include a <p> before Thank you.... July 12, 2004
2: Programming with PHP 44 At the top of the second column, it should say if-elseif-else. August 31, 2004
2: Programming with PHP 51 The very last line of Step 1 should conclude with -->. One hyphen is missing. September 26, 2003
2: Programming with PHP 56 In Table 2.3, the key for Iowa should be IA. October 26, 2003
2: Programming with PHP 58 On line 37 of Script 2.8, there is an extraneous Ü. June 19, 2003
2: Programming with PHP 67 In Script 2.11, line 37 should refer to the variable $name, not {$_POST['name']}. The same applies in Step 4. October 18, 2003
2: Programming with PHP 67 On line 37 of Script 2.11 and in the code to Step 4, the echo statement should begin with an opening P tag, which is closed at the end of the statement. February 15, 2005
2: Programming with PHP 70 In the second tip, it should be described as a mnemonic device, not a pneumonic one. September 02, 2003
2: Programming with PHP 71 Line 14 of Script 2.13 humiliatingly has the movie Casablanca spelled incorrectly. This error also applies to Step 2 on page 72 and Figure 2.30 on page 73. July 21, 2003
3: Creating Dynamic Web Sites 90 Step 2 is missing the line

The corresponding script is correct.
February 12, 2004
3: Creating Dynamic Web Sites 95 On line 21 of Script 3.9, \$$_POST['price'] should read \${$_POST['price']}. The code in the corresponding Step 3 on page 96 is correct. July 23, 2003
3: Creating Dynamic Web Sites 101 On line 46 of Script 3.11, there's an extra "OK" at the end of the comment. February 19, 2005
3: Creating Dynamic Web Sites 104 In the first paragraph, line three should conclude with ...the process is as simple as.... January 06, 2004
3: Creating Dynamic Web Sites 111 In Script 3.14 there is an extraneous double quotation mark at the end of line 10. July 23, 2003
3: Creating Dynamic Web Sites 116 Line 17 of Script 3.16 should read if ($value == $this_month) {. This also applies to Step 3. July 21, 2003
3: Creating Dynamic Web Sites 117 In Step 5, the code $end = $year + 10; and the reference to the $end variable in the while loop is not necessary. The corresponding script, which has the end year of 2010 hardcoded, is correct. February 09, 2004
4: Introduction to SQL and MySQL 121 In Table 4.2, VARCHAR should be described as a variable-length field. This error is repeated in Table C.12 on page 535. July 17, 2003
4: Introduction to SQL and MySQL 145 The Tip that begins Unlike a WHERE clause... no longer applies to the current version of MySQL. October 01, 2003
5: Advanced SQL and MySQL 160 In the third tip, it should read ...for the approved column. July 20, 2003
5: Advanced SQL and MySQL 179 In the sidebar, the first ADDDATE() example is missing a D. It should read ADDDATE(date, INTERVAL 2 HOUR). June 28, 2003
5: Advanced SQL and MySQL 179 The last sentence of the sidebar should read ....you want to subtract one year.... June 29, 2003
5: Advanced SQL and MySQL 179 In the sidebar, at the end of the second paragraph, it should be YEAR_MONTH, not YEARS_MONTH. June 30, 2004
6: Using PHP and MySQL 200 Line 14 of Script 6.5 is missing the question mark which begins the closing PHP tag. It should read ?>. September 26, 2003
6: Using PHP and MySQL 208 On page 208, in the second paragraph under Step 7, It should read This query itself is similar to those demonstrated in Chapter 4. (not Chapter 3). September 04, 2003
6: Using PHP and MySQL 213 On line 15 of Script 6.7, the word Registered is spelled incorrectly. This also applies to Step 3 on page 214. July 06, 2003
6: Using PHP and MySQL 232 In Step 8, there should be one more closing curly brace at the end of the code, which closes the main Submit conditional. The corresponding script is correct. August 27, 2004
7: Cookies and Sessions 241 In Script 7.1, line 80 should begin with </fieldset> to close the fieldset tag. The same applies to the end of Step 7 on page 242. September 03, 2003
7: Cookies and Sessions 270 In the first line of the third paragraph, it should be session.gc_maxlifetime March 22, 2006
8: Security 280 In the last paragraph in the left-hand column, $HTTP_SEVER_VARS should be $HTTP_SERVER_VARS. July 05, 2003
8: Security 303 In four places in Step 3, the regular expression pattern errantly has {2,3} instead of {2,4} as it is in the script. March 11, 2004
8: Security 303 Line 42 of Script 8.5 should refer to $_POST['name'] in order to be register_globals compliant. This also applies to Step 4 on page 304. March 03, 2004
9: Web Application Development 317 In step 2, the command should begin bin/safe_mysqld... (it's missing an l). January 02, 2004
10: Extended Topics 335 Script 10.1 is missing its closing </fieldset> tag. It should appear before line 70. This also applies to Step 9 on page 336. March 20, 2004
10: Extended Topics 350 In Script 10.6, line 18 should read $ext = substr ($_GET['image'], -4);. The corresponding code in Step 3 is correct. October 29, 2003
10: Extended Topics 351 In Step 4, the $_GET variable is missing its curly braces. Line 25 of the corresponding script is correct. March 20, 2004
11: Example--Content Management 366 Step 3 contains the code class="copyright". This is not part of the actual script (and there's no copyright class in the CSS file) and should be omitted. October 12, 2003
11: Example--Content Management 373 In Script 11.5 and in Step 5, the $_POST['type3'] clause has a closing parentheses in the wrong place. That line should conclude with
OR ($_POST['type3'] > 0 )) {
September 10, 2004
11: Example--Content Management 374 Line 78 of Script 11.5 demonstrates how to reset the submitted values, as stated in the penultimate tip on page 379. It's not, however, included in the steps (Step 8). March 06, 2004
11: Example--Content Management 399 In Step 6 and on line 22 of Script 11.9, the first header() line should be
header("Content-Type: $ft");
May 01, 2005
12: Example--User Registration 426 Line 48 of Script 12.7 has an extra slash in the closing </font> tag. June 12, 2003
12: Example--User Registration 426 In Script 12.7 on line 67, there should be a closing </fieldset> tag before the form is closed. The same applies to Step 7. October 23, 2003
13: Example--E-Commerce 481 In the code under Step 4, and on line 32 of Script 13.6, the anchor tag for the print link is never closed. December 14, 2004
13: Example--E-Commerce 489 In Script 13.8, line 5 should read $pid = $_GET['pid'] in order to work with register_globals off. The same applies to Step 2 on page 490. December 02, 2003
13: Example--E-Commerce 496 On the fourth line in the first column, it should be ...I multiply.... January 29, 2005
Ap A: Installation 503 The installation instructions for PHP on Mac OS X have changed. Marc Liyanage now provides a downloadable installer. See www.entropy.ch/software/macosx/php for instructions. October 17, 2003
Ap A: Installation 512 Some Windows users are finding that they shouldn't use quotation marks when creating the root user password. If you have problems, try this command instead:
mysqladmin - u root password newpassword
January 06, 2004
Ap A: Installation 515 The FILE permissions are no longer assignable on a database level. Remove it from the list of permissions in Step 5. October 25, 2003
Ap C: Reference 529 In Table C.2, the third item on the first line should be the decrement operator (--). May 27, 2005
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 and MySQL for Dynamic Web Sites: Visual QuickPro Guide (1st 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
Page #
Book Error
Your Name
Your Email Address

Search This Book!


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


If you have a question, are seeking information, want to download files, or generally have any need related to a specific book, please make sure you are in the correct Web site. Check both the title and the edition.