close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Help with repeating tables

Thread began 12/22/2015 12:06 pm by iain331081 | Last modified 12/23/2015 8:01 pm by iain331081 | 1231 views | 8 replies

iain331081

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?

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...