MySQLi repeating region does only return values, if there are at least 10 values to return, otherwise it returns nothing.

On the detail page, rspricetable will return rows, but only if at least 10 rows can be returned (depending on the product_id). For less rows it returns nothing.

rsextraimages returns nothing (this may be the same problem). I suspect something is wrong with the recordset.

I have tried deleting the repeating behaviors and adding them again, but it made no difference. I also tried setting to the behavior to an arbitrary number for rows to be returned without any change.

This is the online link for a product that returns all rows (first picture): http://neu.segufix.com/detail.php?recordID=13

This product only has one row, but nothing is returned (second picture): http://neu.segufix.com/detail.php?recordID=1

It looks like the content is coming from rspricetable. I'd start by debugging that query and see why it doesn't return results. It is unlikely that it has anything to do with the number of results.

I see you have several INNER JOIN statements, so it could be missing rows in other tables causing the issue.

I'd add this to the page above the table:
<?php echo($rspricetable->debugSQL()); ?>

Then run that in phpMyAdmin to see if there are rows returned. It might be a missing row in the tblsize table or tblprice or tblversion.... Try changing them all to LEFT OUTER JOIN and then you will get results even when the joined table is empty. Most likely the issue is invalid data in one of the joined id columns.

I am not sure what running that in phpMyAdmin means, but I changed to LEFT OUTER JOIN. When I test the SQL for the record ID 1 in Dreamweaver, it returns a row. It didn't before. But when I test the page, it will still not return the row.

Maybe your live database has different data?

If you go to phpMyAdmin and run the query:

SELECT DISTINCT tblproduct.product_id, tblsize.size_id, tblsize.size, tblversion.version_id, tblversion.version, tblprice.price_id, tblprice.price, tblprice.price_can, tblprice.item_no_long, tblprice.pzn_no, tblprice.sorting FROM tblproduct LEFT OUTER JOIN tblprice ON tblprice.product_id = tblproduct.product_id LEFT OUTER JOIN tblsize ON tblprice.size_id = tblsize.size_id LEFT OUTER JOIN tblversion ON tblprice.version_id = tblversion.version_id WHERE tblproduct.product_id = 1 ORDER BY tblprice.sorting

Do you get a result?

I don't see the debugSQL value on the live site... are you sure you uploaded it?

I works now. After running the query in PHP MyAdmin. Both online and local. The problem was indeed, that some products have no size and/or no version. And those happened to be the products with a low number of returned rows.