Checked list field displays an image - how to?

Hi Tina,

Based on some of the recipes in my CMSB Cookbook http://www.thecmsbcookbook.com you might try something like this:

<?php foreach ($your_tableRecords as $record): ?>

<?php if ($record['your_check_box_field'] == 0) : ?><img src="http://www.your_site.com/your_image_folder/image_for_no_image.jpg" width="???" height="???" /><?PHP endif ?>
<?php if ($record['your_check_box_field'] == 1) : ?><img src="http://www.your_site.com/your_image_folder/image_for_sold.jpg" width="???" height="???" /><?PHP endif ?>
<?php if ($record['your_check_box_field'] == 2) : ?><img src="http://www.your_site.com/your_image_folder/image_for_reduced.jpg" width="???" height="???" /><?PHP endif ?>
<?php if ($record['your_check_box_field'] == 3) : ?><img src="http://www.your_site.com/your_image_folder/image_for_new.jpg" width="???" height="???" /><?PHP endif ?>
<?php echo $record['another_field'] ?>
<?php echo $record['another_field'] ?>
<?php echo $record['another_field'] ?>
<?php endforeach ?>

It's very simple, uses fixed images and image locations and has no styling, but it should get you started.

Hope it helps,

Jerry Kornbluth

Thanks Jerry!

I've been hacking at this thing for awhile now and I get it close, but never perfect. I found a few more examples and tried to go from there, but again, no luck.

I'm hoping it's just something obvious I'm missing. Can you take a look please? As it is right now I had to remove it from the page because the page shows a complete blank when this code is added:

<?php foreach ($listingRecords as $record): ?>
<?php if ($record['banner_status'] == Sold) : ?><img src="http://www.dunhamrealestateservices.com/images/bnr-sold.jpg" width="312" height="25" /><?PHP endif ?>
<?php if ($record['banner_status'] == Reduced) : ?><img src="http://www.dunhamrealestateservices.com/images/bnr-reduced.jpg" width="312" height="25" /><?PHP endif ?>
<?php if ($record['banner_status'] == New) : ?><img src="http://www.dunhamrealestateservices.com/images/bnr-new-listing.jpg" width="312" height="25" /><?PHP endif ?>
<?php echo $record['banner_status'] ?>
<?php echo $record['banner_status'] ?>
<?php echo $record['banner_status'] ?>
<?php endforeach ?>

Thanks so much! Tina

Hi tina,

I think if you put single quotes around 'Sold' 'Reduced' and 'New' it will solve the problem.

Jerry Kornbluth

I'll give that a shot. Thanks!!

Let me know if you need more help

Jerry Kornbluth

Hi Jerry,

Well, maybe it's the week I'm having or it's just beyond my limited skills ;)

I tried a few variations on this but got the same result. The Image is now showing properly (yeah!) but now all listings are marked "new" when in reality, I only have one test property marked "new" at this moment.

Using this code:

<?php foreach ($listingRecords as $record): ?>
<?php if ($record['banner_status'] == 'Sold') : ?><img src="http://www.dunhamrealestateservices.com/images/bnr-sold.jpg" width="312" height="25" /><?PHP endif ?>
<?php if ($record['banner_status'] == 'Reduced') : ?><img src="http://www.dunhamrealestateservices.com/images/bnr-reduced.jpg" width="312" height="25" /><?PHP endif ?>
<?php if ($record['banner_status'] == 'New') : ?><img src="http://www.dunhamrealestateservices.com/images/bnr-new-listing.jpg" width="312" height="25" /><?PHP endif ?>
<?php endforeach ?>

I have a dummy image of the same dimension: bnr-none.png

I was trying to get it so if none are marked, then it would either display nothing or the dummy image, either one would be fine. My tests didn't work out.

Here's the listings page (all marked "NEW LISTING")
http://www.dunhamrealestateservices.com/listings.php?property_type=Residential

and my listingdetail page marked as "new"
http://www.dunhamrealestateservices.com/listingDetail.php?Condo-for-Sale-in-Red-Lodge-MT-38

(not sure about the definition of "condo" here... ) ;) So the listing detail page is fine. I even checked by changing it from "new" to "reduced" and "sold"... each time the new banner status carried over to the listings page as well.

Your help is much appreciated. Thanks again!!

Hi Tina,

Looks like you're really close.

On the list page, insert the line: <br /><?php echo $record['banner_status'] ?><br /> in the loop before the <?php endforeach ?> and see what you get as the Banner Status for each record.

You can insert the line: <br /><?php echo $listingRecord['banner_status'] ?><br /> on the detail page to see what's being returned there as well.

That should give you a clue as to what's going on.

Jerry Kornbluth

Hi Tina,

Sorry that this is becoming so frustrating for you.

I also noticed that page 2 doesn't have any new image or "New" text.

Could you attach the list page and detail page viewers with the code inserted that gives you the error so I can see exactly what you're doing?

BTW: When working on a live site, you might want to copy the viewer you're working on and call it listinga.php. If you play with that one, your client won't see the changes until they're done.

You can do the same with the detail page, but you'd have to hard code the detail page link address (http://www.dunhamrealestateservices.com/listingDetaila.php) into the list page code because $record['_link'] will automatically pull up the original detail page.

Best,

Jerry Kornbluth