I am in chapter 10 of Jeff Bardzells DW w ASP/CF/PHP (I'm using PHP) Book and have run into an error whenever I try to create SQL recordset.

Recordset SQL:
SELECT * FROM tbl_tours INNER JOIN tbl_country ON tbl_country.countryID = tbl_tours.country ORDER BY tbl_country.countryName

Error Message:
"An unidentifed error has occurred."

Could there be a problem with my MySQL or PHP install or config?

Thanks

what I've found really good for checking out problems like this is to use phpmyadmin where you can paste in your sql and run it immediatley - that's how I experiment and get my sql right, messy I know but it works <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>