ok Im attaching the 3 tables as images and I am attaching a crude example I put together in photoshop (however because of the featured table it will allow me to control in which order the products and feedback are displayed for each individual page).
plus i am copying the current code to display the actual repeat region to give it context.
<?php
if ("".$row_rsFeatured['FeaturedType'] ."" == "1") { // WebAssist Show If
?>
<div class="feature-heading">Featured Product</div>
<?php do { ?>
<p class="feature-name"><?php echo $row_rsFeatured['ProductName']; ?></p>
<div class="clearfix"></div>
<p class="feature-price">From only £<?php echo $row_rsFeatured['ProductPrice']; ?></p>
<p class="feature-image"><a href="../product.php?Product=<?php echo $row_rsFeatured['ProductLink']; ?>"><img src="../images/products/large/<?php echo $row_rsFeatured['ProductImage']; ?>" width="250" alt="<?php echo $row_rsFeatured['ProductImageTitle']; ?>"/></a></p>
<?php } while ($row_rsFeatured = mysql_fetch_assoc($rsFeatured)); ?>
<?php
} // ("".$row_rsFeatured['FeaturedType'] ."" == "1")
?>
<div class="clearfix"></div>
<?php
if ("".$row_rsFeatured['FeaturedType'] ."" == "2") { // WebAssist Show If
?>
<div class="feedback-heading">What our Customers say!</div>
<p class="feedback-other"><a href="../what-our-customers-say.php">Read other Customer Reviews</a></p>
<?php do { ?>
<div class="clearfix"></div>
<p class="feedback-quote"><?php echo $row_rsFeatured['FeedbackText']; ?></p>
<p class="feedback-name"><strong><?php echo $row_rsFeatured['FeedbackSalutation']; ?> <?php echo $row_rsFeatured['FeedbackFirstName']; ?> <?php echo $row_rsFeatured['FeedbackLastName']; ?> | <?php echo $row_rsFeatured['FeedbackLocation']; ?></strong></p>
<p class="feedback-date"><?php echo date('jS M Y',strtotime($row_rsFeatured['FeedbackDate'])); ?></p>
<?php } while ($row_rsFeatured = mysql_fetch_assoc($row_rsFeatured)); ?>
<?php
} // ("".$row_rsFeatured['FeaturedType'] ."" == "2")
?>
and obviously to determine the page i am using
$basefile = basename ( $_SERVER["REQUEST_URI"] );
WHERE FeaturedLocale = '$basefile'
the basefile is stored in the featured table under FeaturedLocale
the ProductID OR FeedbackID is stored in the featured.FeaturedTypeID table.
AND FeaturedType 1 means a product and FeaturedType 2 means feedback
(currently im not using FeaturedPosition as of yet (but in the future this will allow the client to reposition content)
Chris