region not showing

Hey Jason

Have created a couple of regions in the attached file which depend on whether or not the 'Live' row is set to 0 (not live) or 1 (live)

I have got the error message working and will show if there is no data or the data is set to Live = 0

What I'm struggling with is to show the testimonial if one is available (eg Live = 1) but it doesnt show anything in the space on the page (the error message doesnt show either).

What have I done wrong please? file attached

after this code:
<?php
$showError = 0;
do{
if($row_Testimonials['Live'] == 1) $showError = 1;
} while ($row_Testimonials = mysql_fetch_assoc($Testimonials));

$showTestimonials = 0;
do{
if($row_Testimonials['Live'] == 1) $showTestimonials = 1;
} while ($row_Testimonials = mysql_fetch_assoc($Testimonials));
?>

you need to reset the recordsets to the beginning.

place your cursor after that code block, open the server behaviors panel and select WebAssist -> Dynamic Webcharts -> Reset to first record.

add the behavior for each recordset.

I had done that (and have redone it) but no joy.

The attached screenshot shows where the testimonial (if one is active) should be but its not showing. Have also re-added the page itself with the adjusted code.

I'll need to troubleshoot directly, see the private message section.

See PM

you are using the same repcrdset in both loops, so the recordset needs to be reset after the first loop and again after the second loop:

<?php
$showError = 0;
do{
if($row_Testimonials['Live'] == 1) $showError = 1;
} while ($row_Testimonials = mysql_fetch_assoc($Testimonials));
?>
<?php
$chk_rows = mysql_num_rows($Testimonials);
if ($chk_rows > 0) {
mysql_data_seek($Testimonials, 0);
$row_Testimonials = mysql_fetch_assoc($Testimonials);
}
?>
<?php
$showTestimonials = 0;
do{
if($row_Testimonials['Live'] == 1) $showTestimonials = 1;
} while ($row_Testimonials = mysql_fetch_assoc($Testimonials));
?>
<?php
$chk_rows = mysql_num_rows($Testimonials);
if ($chk_rows > 0) {
mysql_data_seek($Testimonials, 0);
$row_Testimonials = mysql_fetch_assoc($Testimonials);
}
?>

Gotcha. Thanks Jason

you're welcome.