I am using Jeff Bardzell's PHP/MYSQL/DW book and everything has worked fine until I tried either of these two SQL's:
SELECT *
FROM tbl_tours INNER JOIN tbl_country
ON tbl_country.countryID=tbl_tours.country
ORDER BY tbl_country.countryName
SELECT *
FROM tbl_tours, tbl_country
WHERE tbl_country.countryID=tbl_tours.country
ORDER BY tbl_country.countryName
Also,
There is a warning on PHPMyAdmin page:
"Your PHP MySQL library version 5.0.24a differs from your MySQL server version 5.0.45. This may cause unpredictable behavior."
If this is the problem I am unsure how to fix it. Any help is greatly appreciated.