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:
Click on a column heading to sort the table by that column.
| Chapter | Page # | Description | Date Added |
|---|---|---|---|
| 4: Creating a MySQL Database | 73 | In Table 4.2, the description of the second item, VARCHAR, erroneously says that it’s a fixed-length field. That should read a “variable-length” field. | August 30, 2007 |
| 5: Basic SQL | 102 | The last bullet point should say “The word NULL must not be quoted.” (“word”, not “world”). | May 24, 2009 |
| 5: Basic SQL | 106 | The “clients” table definition (see page 95) sets all the client address information as NOT NULL. Therefore, the INSERT commands on page 106 will not work as written. Either change the table definition or add address values to the INSERT queries. | August 30, 2007 |
| 5: Basic SQL | 110 | The INSERT queries in Step 4 erroneously quote numeric values. The queries still work but numbers don’t need to be quoted. | July 9, 2008 |
| 5: Basic SQL | 115 | In Step 2, the query should be SELECT * FROM clients WHERE contact_last_name LIKE ‘Doe’\G. | November 14, 2006 |
| 6: MySQL Functions | 135 | The caption to Figure 6.3 should say that the second through fourth characters are returned. | July 9, 2008 |
| 6: MySQL Functions | 148 | In the first paragraph, it says that the conditional limits results to the previous six months. This should say to the previous two months. | January 23, 2007 |
| 7: MySQL and PHP | 174 | The very last line is missing the “L” in $num = mysqli_num_rows($query_result); | July 10, 2007 |
| 7: MySQL and PHP | 177 | The code in Step 3 refers to mysql_connect.inc.php. That should actually be mysqli_connect.inc.php. The code in the corresponding script (Script 7.3, line 17) is correct. | January 23, 2007 |
| 7: MySQL and PHP | 194 | In Script 7.6, on line 36, it should say if (@mysqli_affected_rows($dbc) == 1) {. This change also applies to Step 6 on page 196. |
November 14, 2006 |
| 10: Advanced SQL and MySQL | 299 | In the explanation of the code under Step 3, the “at symbol” (also called the “at sign” or “asperand”) is mistakenly called an “ampersand”. | October 26, 2009 |
| 12: Techniques for Programming | 367 | In Step 6, the INSERT query should begin INSERT INTO films (director_id, title, year_released) VALUES. | June 20, 2006 |