php MySQL limits

Hi all,

Here’s an interesting query, is there a limit to the number of record that can be retreived and displayed using freeway?

I seem to have hit a limit whereby the last two tables aren’t showing any products. Have a look at this page, which is a landing page for a Google Adwords ad which needs to show all the products available. Anyway, this is what I’ve done:

http://www.cotswoldengineeringsupplies.co.uk/Hose%20Clips%20and%20Clamps/index.php

Click on the “Mikalor Clips and Clamps – Click here to reveal” grey panel, then on “Mikalor Clips and Clamps – 2 Ear O Clips, Stainless Steel” to reveal the products, this is complete. Click on the next grey panel “Mikalor Clips and Clamps – Supra W2 Stainless Steel Band” This has only one product shown, and the last panel is blank.

If you want to check what should be there, go to the left hand menu, in the purple section, and select:

Mikalor Clips and Clamps > Supra Hose Clamps > Supra W2 Stainless Steel Band

As you can see only the first one is shown.

Is there a way to fix this?

Best wishes

Steve.


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

If you try issuing the same query in phpMyAdmin, what happens? Sure,
there are limits in PHP/MySQL, but they are extremely, ridiculously
high. Freeway has nothing to do with this, when you use PHP to loop
over a set of records, you would have to be in the tens of thousands
of rows on the page to make the thing blow up a browser, and you’d be
in the millions of rows of results before you overran the memory
limits of your server.

Walter

On Sep 23, 2010, at 5:05 PM, SteveB wrote:

Hi all,

Here’s an interesting query, is there a limit to the number of
record that can be retreived and displayed using freeway?


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Hi Walter,

I’ve been away from the office since Friday (short break in Derbyshire), so I wasn’t able to test the query in phpMyAdmin.

On getting back, I checked all the php code that sorted the products out into their relevant ranges, and found that 2 of the lines had an extra character tacked to the end of the variable. Deleting those pesky little rascals sorted out the last 2 tables.

I should have checked the code more carefully. That’s the trouble with having 14 blocks of code that all look the same except for the last character on each variable.

Thanks for the help, and apologies for not replying sooner.

Best wishes,

Steve.


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options