Thanks Ray - just looking at the code to try to see what's doing what.
Is that using a different method? I thought the other one used data seek to show the first record:
<?php
mysql_data_seek($rsProductUpdates, 0);
$row_rsProductUpdates = mysql_fetch_assoc($rsProductUpdates);
?>
And subsequent records (e.g. 2-10):
<?php for($i=1;$i<=10;$i++) { ?>
<?php
mysql_data_seek($rsProductUpdates, $i);
$row_rsProductUpdates = mysql_fetch_assoc($rsProductUpdates);
?>
With this page it looks like you added LIMIT 21 at the end of the SQL to control how many records appear on the page, and 20 iterations in the repeating table.
But what makes it show the first record at the top, and then records 2-21 in the repeating table?
I'm just wondering how much of a pain it might be to have more than one repeating table on the page to break it up and make it look a little less repetitive, for example:
1 story at the top showing record 1
Repeating table showing records 2 - 5 in a single row of 4
Repeating table showing records 6 - 15 in 4 rows of 2
Repeating table showing records 16 - 19 in a single row of 4
Repeating table showing records 20 - 29 in 4 rows of 2
Or something like that at least.
Would it just be a case of adding more repeating tables, with the specified number of iterations, and altering the LIMIT in the SQL?
Also, I'm using Substr(update_details, 1, 140) AS summary text to limit the text to the the first 140 characters of the news item. Do you know any little tricks to do that without truncating in the middle of a word, i.e. 140 characters + however many before the first blank space, period?
