PHP if/else help

Hi Jason,

Try this:

<?php if (count($record['images']) == 1): ?>
There is only 1 image
<?php endif ?>

or

<?php if (count($record['images']) == 1): ?>
<?php foreach ($record['images'] as $upload): ?>
<li><a href="#">.</a></li>
<?php endforeach ?>
<?php endif ?>

Hope that helps!

hi, i am using an include to show the content that goes in the right column of this site http://www.ibizaedgevillas.com/ (under the special offers header). The included file should show the special offers info if there is content in the special offers field, which works fine. However there is some other content which should only show if there is not any special offers content. For some reason this content is showing even when there is some special offers content. The code that I have used in the included file is below:

<?php

require_once "/home/fhlinux130/i/ibizaedgevillas.com/user/htdocs/cmsAdmin/lib/viewer_functions.php";

list($villas_for_rentRecords, $villas_for_rentMetaData) = getRecords(array(
'tableName' => 'villas_for_rent',
'limit' => '20',
'orderBy' => 'createdDate DESC',
'allowSearch' => false,
));

?>
<?php foreach ($villas_for_rentRecords as $record): ?>
<?php foreach ($record['image'] as $upload): ?>
<?php if ($record['special_offer']): ?>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="<?php echo $upload['info1'] ?>" border="0"/></a>
<?php endif ?>
<?php endforeach ?>
<?php if ($record['special_offer']): ?>
<span class="villaintro"><?php echo $record['special_offer'] ?>. <?php echo $record['availability_left'] ?>. <?php echo $record['beds'] ?> bedrooms.</span><br>
<a href="<?php echo $record['_link'] ?>"><b>view Ibiza villa details...</b></a>
<br><br>
<?php endif ?>
<?php endforeach ?>

<!-- if there is no content in any special offers record -->
<?php if (!$record['special_offer']): ?>
We have regular special offers on our <strong>Ibiza Villas</strong>. <br />
<br />
Please <a href="http://www.ibizaedgevillas.com/contact.php">contact us</a> if you would like to be added to our mailing list.<br />
<br />
If you see any of the same <strong>Ibiza Villas</strong> for rent at a cheaper price feel free to contact us and we will try our best to beat that price.
<?php endif ?>



Can you shed any light on the problem?

Hey,

It looks like the problem is you're checking $record['special_offer'] outside of the foreach loop where it is created. You'll need to set another variable to check at the bottom. For example in your loop add one line so it looks something like this:
<?php if ($record['special_offer']): ?>
<?php $special_offer=1; ?>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>"
width="<?php echo $upload['thumbWidth'] ?>"
height="<?php echo $upload['thumbHeight'] ?>"
alt="<?php echo $upload['info1'] ?>" border="0"/></a>
<?php endif ?>
Then where you check at the bottom:
<?php if (!$special_offer): ?>

Hi, I have another problem on the same web site - http://www.ibizaedgevillas.com

Just to re-cap, the column on the right hand side of the design is used to show special offers by using an include which you can see the code for below. These propogate based on an if statement. Basically if there is content in the special offers field in the cms then show this villa in the special offers column. For some reason some villas are not showing up even if they have content in the special offers field? I think I remember a problem like this before and it was something to do with record numbers? Any ideas?

<?php

require_once "/home/fhlinux130/i/ibizaedgevillas.com/user/htdocs/cmsAdmin/lib/viewer_functions.php";

list($villas_for_rentRecords, $villas_for_rentMetaData) = getRecords(array(
'tableName' => 'villas_for_rent',
'limit' => '20',
'orderBy' => 'createdDate DESC',
'allowSearch' => 0,
));

?>
<?php foreach ($villas_for_rentRecords as $record): ?>
<?php if ($record['special_offer']): ?>
<?php $special_offer=1; ?>
<?php foreach ($record['image'] as $upload): ?>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="<?php echo $upload['info1'] ?>" border="0"/></a>
<?php endforeach ?>
<span class="villaintro"><?php echo $record['special_offer'] ?> <?php echo $record['beds'] ?> bedrooms.</span><br>
<a href="<?php echo $record['_link'] ?>"><b>view Ibiza villa details...</b></a>
<br><br />
<?php endif ?>
<?php endforeach ?>

<!-- if there is no content in any special offers record -->
<?php if (!$record['special_offer']): ?>
We have regular special offers on our <strong>Ibiza Villas</strong>. <br />
<br />
Please <a href="http://www.ibizaedgevillas.com/contact.php">contact us</a> if you would like to be added to our mailing list.<br />
<br />
If you see any of the same <strong>Ibiza Villas</strong> for rent at a cheaper price feel free to contact us and we will try our best to beat that price.
<?php endif ?>

Hi,

How many records are you expecting to see?

If you could fill out a [url http://www.interactivetools.com/support]2nd Level Support Request[/url] I can take a quick look and try to find what the issue is.

Thanks

hi,

sorry for the delay in getting back. i've been out of the office.

i have submitted the details though the second line support form (although it did not give me an indication that the info was submitted successfully, it just re-loaded the page?)

there should be one more vill showing called Casa Avalon (ref 0402). you will see all the villas in the "villas for rent" section when you login. Casa Avalon has some info in the "discounts" field and therefore should be showing in the right column.

thanks for your help, james

Hi,

I've taken a look at the code and found the problem. The issue is that you were selecting all your records, not just the ones with a value for special_offer. This wouldn't be a problem except that you set a limit of 20 records. Your fourth "special_offer" record fell below that 20 record threshold. What I did was to change your query to only select record that had a value in the special offers field like this:
list($villas_for_rentRecords, $villas_for_rentMetaData) = getRecords(array(
'tableName' => 'villas_for_rent',
'limit' => '20',
'orderBy' => 'createdDate DESC',
'allowSearch' => 0,
'where' => "special_offer != '' ",
));
Then then could remove the "if" statement completely.

Hope this helps.

that makes sense. easy when you know how!

thanks for your help. much appreciated.