Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › MySQLi repeating region does only return values, if there are at least 10 values to return, otherwise it returns nothing.

View all replies to this thread

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

Thread began 9/03/2019 1:45 pm by Roxana | Last modified 9/05/2019 11:13 am by Roxana | 422 views | 4 replies

9/03/2019 3:24 pmRay BorduinWebAssist

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?

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.