recordset problems

Hi Jason

Am trying to figure out why 1 page shows/doesnt show data depending on the category selected.

1. http://www.hairmekanix.co.uk/detail-category-test.php?id=8 - All works as expected

2. http://www.hairmekanix.co.uk/detail-category-test.php?id=6 - no data is returned nor is the breadcrumb or section populated with the correct category name (in this case it should be 'Ethical Products')

3. http://www.hairmekanix.co.uk/detail-category-test.php?id=10 - This one is populating the section and breadcrumb categories but is only showing one product when there are 10+ items in the database associated with that category)

I have attached the file if you need it

thanks

Jamie

I'll need to troubleshoot directly, see the private message section.

thanks Jason

in your recordset, change the join type from:
INNER JOIN

to:
LEFT JOIN

since you dont have matches in all of the tables being joined, you are not getting all the results you are expecting.

see this page for more details on the different join types and their uses:

http://en.wikipedia.org/wiki/Join_(SQL)

thanks Jason. funnily enough I was going to be asking a question about INNER vs LEFT - will take a look at your reference material

thanks again

Jamie

an INNER join requires a match on both sides.

Left join will return all records from both tables even if the table on the right has a NULL value.