Errata

reads...

if ($var > 5)
{
echo "Variable is less than 5";
echo "-----------------------";
}
else
{
echo "Variable is equal to or larger than 5";
echo "-----------------------";
}

it should read...

if ($var > 5)
{
echo "Variable is larger than 5";
echo "-----------------------";
}
else
{
echo "Variable is equal to or less than 5";
echo "-----------------------";
}

In this quote

"The incorrectly formed conditional expression ($var = 1) always evaluates
as true,because the assignment that actually occurs always succeeds and,
therefore, is always true."

The implication is that any c.e. of this form will always evaluate to
TRUE because it's the assignment that matters. In fact it's the value
on the right hand side of the '=' that matters. If the '1' had been
a '0', then the c.e. would be FALSE. It seems to work the same as it
does in perl where I have often used this ideom to both assign and
test the return value of a function.

if ($var == 3) || ($var == 7)
echo "Equals 3 or 7";

it should be like this

if (($var == 3) || ($var == 7))
echo "Equals 3 or 7";

// prints "The quick brown fox"

should be:
// prints "The quick brown fox jumps"

{92/93} 92-bottom / 93 - top;
switch($headinglevel)
{ <= missing
[snip]
} <= missing

example 3-1
In the CREATE TABLE wine query - there should be a comma , after KEY name (wine_name)

In the CREATE TABLE winery query - there should be a comma , after KEY name(winery_name)

In the example 3-2 (page 120) you have: salary and birth_date transposed in
their table positions.

"...retrieves the tenth row of the result set."

SHOULD BE:
"...retrieves the eleventh row of the result set."

if (!($connection = @ mysql_connect($hostname,
should be
if (!($connection = @ mysql_connect($hostName,

if (!(mysql_select_db("winestore", $connection)))
should be
if (!(mysql_select_db($databaseName, $connection)))

Only one row should be produced per wine, not one per inventory. To do this,
remove the inventory table attributes from the SELECT statement and add a DISTINCT
to remove the duplicates. However, you can't remove the inventory table fully from
the query, because you still need to ORDER BY date_added to display the newest wines
added to our winestore cellar. The query is now as follows:

$query = "SELECT wi.winery_name,
w.year,
w.wine_name,
w.description,
w.wine_id
FROM wine w, winery wi, inventory i
WHERE w.description != ""
AND w.winery_id = wi.winery_id
AND w.wine_id = i.wine_id
GROUP BY winde-id
ORDER BY i.date_added DESC LIMIT 3";

With this modified query, one entry is produced per wine. However, having removed the
inventory attributes, you no longer have the pricing information.

Should say -

One approach is to remove the inventory table attributes from the SELECT statement
and add a DISTINCT to remove the duplicates. Another approach is to remove the
inventory attributes and add a GROUP BY wine_id. For example, the query
would now be as follows:

$query = "SELECT wi.winery_name,
w.year,
w.wine_name,
w.description,
w.wine_id
FROM wine w, winery wi, inventory i
WHERE w.description != ""
AND w.winery_id = wi.winery_id
AND w.wine_id = i.wine_id
GROUP BY winde-id
ORDER BY i.date_added DESC LIMIT 3";

However, these approaches don't work, because you can't remove the inventory table
since you need the ORDER BY date_added to display the newest wines. Instead, we
take a different approach.

The first query on the page contains the line:

GROUP BY winde-id

This should be:

GROUP BY w.wine_id

The query at the start of the function showPrices lacks quotes.

In the function showPrices, when the pricing information is printed the
$row["min(cost)"] and $row["min(case_cost)"] are interchanged.

The scipt of Example 5.5 does not include the file error.inc Therefor the
function showerror() can not be called.

After the use of the function mysql_connect() the function showerror() is
used, this shoud be die("Could not connet").

The variable $numRowsToFetch in the 6th line of the code fragment
on page 235 should be replaced with the constant ROWS.

The book version displays the current page as a link, when it
should be displayed as static text.

The code has been updated on the author's web site at http://www.webdatabasebook.com/

the function selectDistinct() does not take a $database parameter at all
Correct: Delete the last bullet point on p.237.

The piece of code should be replaced with:

// Extract the domain of the email address
$maildomain = substr(strstr($formVars["email"], '@'), 1);

elseif (!( getmxrr($maildomain, $temp) || gethostbyname($maildomain) != $maildomain
))
// Can email be sent to this domain?
$errors["email"] = "The domain does not exist.";

The function getmxrr( ) queries an Internet domain name server (DNS) to
check if there is a record of the email domain as a mail exchanger (MX). If
the domain isn't an MX, the domain is checked with gethostbyname( ) to see
if it has an A record; the relevant standard RFC-974 states that when a
domain does not have an MX, it should be interpreted as having one equal to
the host name. If both tests fail, the domain of the email address isn't
valid and we reject the email address.

The parentheses for the last 'if' expression are unbalanced:
"if (($depBits[3] == "pm" && $arrBits[3] == "am")) ||" should be
"if (($depBits[3] == "pm" && $arrBits[3] == "am") ||"

"scrollbar=yes"

SHOULD BE:
"scrollbars=yes"

the function should return the string, rather than echo the string, as it is echo'd
when the function is called. The same goes for the full code listing on page 334

start_session(); should be session_start();

example shows function definition as
function sessionClose($sess_id)
The function does not take a parameter and should be
function sessionClose()

AUTHOR: The reader is correct (though it doesn't actually cause anything bad to
happen). I won't change it in the online source distribution, but I would
fix it in a 2nd edition of the book.