child not displaying correctly

I created a data model using Model Database. The database I am using is defined using the Dynamic My SQLi Connection and test is successful. I have a categories table and an inductees table, where there is 1 unique category title in the categories table, but many inductees could also be tagged with that category. I created a MySQLi Recordset titled category. In the advanced mode, I used the Query Builder to create the SQL statement

"SELECT inducteecat.*, inductees.*
FROM inducteecat INNER JOIN inductees ON inducteecat.category = inductees.category LIMIT 1"

When run the test, the SQL statement returns 60 records which is how many inductees I have. But data in the columns reported is not correct. The category field from the category table matches the category field in the inductee's field, but the inductees last name, class year and image name are blank, and the firstname field is reporting the inductees class year. What do you think is happening?

I can't say. The query looks correct. Have you tried running that query in PHPMyAdmin? Does it work on the page or is it just Dreamweaver's test function causing issues?

I went to mysql and ran the following script. It reported all lines and fields as expected.

SELECT `years`.`year`, `inductees`.`year`, `inductees`.`lastname`
FROM years INNER JOIN inductees on `years`.`year` = `inductees`.`year`
ORDER BY `years`.`year` ASC

Try using that query instead on your page. I think the issue is that you are using a column named "year" which is a reserved word in MySQL. You should avoid column names like that.