[PHP and MySQL for Dynamic
Web Sites: Visual QuickPro Guide](/books/php-and-mysql-for-dynamic-web-sites-visual-quickpro-guide/)
Unfortunately, despite the best efforts of myself, the technical editor, the copy editor, the line editor, the proofreader, and despite the multiple revisions, errors still occur. This page lists all the errors found in the book since it went to print.
Note: errors are corrected in subsequent printings and therefore your particular copy may not contain all of the following. You may also be experiencing problems not caused by a mistake in the book. If so, you may find the solution to your problem by using the book’s corresponding forum. Significant 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:
\['name'\]}. The same applies in Step 4.October 18, 20032: Programming with PHP67On 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, 20052: Programming with PHP70In the second tip, it should be described as a mnemonic device, not a pneumonic one.September 2, 20032: Programming with PHP71Line 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, 20033: Creating Dynamic Web Sites90Step 2 is missing the line
1
The corresponding script is correct.February 12, 20043: Creating Dynamic Web Sites95On 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, 20033: Creating Dynamic Web Sites101On line 46 of Script 3.11, there’s an extra “OK” at the end of the comment.February 19, 20053: Creating Dynamic Web Sites104In the first paragraph, line three should conclude with …the process is as simple as….January 6, 20043: Creating Dynamic Web Sites111In Script 3.14 there is an extraneous double quotation mark at the end of line 10.July 23, 20033: Creating Dynamic Web Sites116Line 17 of Script 3.16 should read if ($value == $this_month) {. This also applies to Step 3.July 21, 20033: Creating Dynamic Web Sites117In 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 9, 20044: Introduction to SQL and MySQL121In 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, 20034: Introduction to SQL and MySQL145The Tip that begins Unlike a WHERE clause… no longer applies to the current version of MySQL.October 1, 20035: Advanced SQL and MySQL160In the third tip, it should read …for the approved column.July 20, 20035: Advanced SQL and MySQL179In the sidebar, the first ADDDATE() example is missing a D. It should read ADDDATE(date, INTERVAL 2 HOUR).June 28, 20035: Advanced SQL and MySQL179The last sentence of the sidebar should read ….you want to subtract one year….June 29, 20035: Advanced SQL and MySQL179In the sidebar, at the end of the second paragraph, it should be YEAR_MONTH, not YEARS_MONTH.June 30, 20046: Using PHP and MySQL200Line 14 of Script 6.5 is missing the question mark which begins the closing PHP tag. It should read ?>.September 26, 20036: Using PHP and MySQL208On 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).
in order to work with register_globals off. The same applies to Step 2 on page 490.December 2, 200313: Example–E-Commerce496On the fourth line in the first column, it should be …I multiply….January 29, 2005Ap A: Installation503The 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, 2003Ap A: Installation512Some 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 newpasswordJanuary 6, 2004Ap A: Installation515The FILE permissions are no longer assignable on a database level. Remove it from the list of permissions in Step 5.October 25, 2003Ap C: Reference529In Table C.2, the third item on the first line should be the decrement operator (–).May 27, 2005