Trouble displaying information from table in PHP, please help.

[Costa Gauci]

Hi there,

I'm learning PHP and have come across a problem I'm wondering if one of you can help me with.

I'm trying to run this code from Addison Wesley PHP and MySQL Web Development 4th Edn. When I try to run it, it comes up with a connection error but when I remove 'books' from line 22 it connects but doesn't seem to display any search results.

The code can be found here:

http://pastebin.com/diff.php?i=b7Zcez2g

Since then I have tried improving on the way I connect to the code but still receive no results, the new code can be found here:

http://pastebin.com/diff.php?i=b7Zcez2g

I am still very new to PHP and MySQL so would greatly appreciate any help given.

The information is definitely found in the database as shown here:



And the live docs can be found here:

http://www.uncensoreddesign.co.uk/php/book-o-rama/search.html

Many thanks,

Costa