I am absolutely sure the connection, database, etc is valid.
If I shorten the sql query:
$getBookResources = "SELECT author_lastname, author_firstname, title FROM BookTable";
I actually get a result set from PHP. It doesn't like my join. I have tried the INNER JOIN as stated, and I have tried the more traditional "from TableX x, TableY y where x.id = y.id" with the same results (or lack of results) from php.
The next question will certainly be about my tables:
CREATE TABLE BookTable (
book_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
title varchar(128),
author_lastname varchar(64),
author_firstname varchar(64),
publish_date date,
description varchar(4096),
category_id int(10) UNSIGNED,
PRIMARY KEY (book_id),
FOREIGN KEY (category_id) REFERENCES CategoryTable(category_id)
)
AUTO_INCREMENT=200
ENGINE=InnoDB;
CREATE TABLE CategoryTable (
category_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
primary_category varchar(64) NOT NULL,
secondary_category varchar(64),
PRIMARY KEY (category_id)
)
AUTO_INCREMENT=200
ENGINE=InnoDB;
-Lynch