Conditional Display of Field

If statement are really versatile and powerful concepts.

If you think that an "If" statement will do the job for you, then here's some code that should work for you.

The first rule to remember is that every (series of) if statement(s) must be closed with an <?php endif ?> in order for them to work correctly.

The second rule is that if you’re using a series of if statements, then the first one is always an “if”, the last is always “else” and any in the middle are “elseif”.

If you wanted to test for particular contents in “your_field”. Say, if the contents of “your_field” equaled “apples” then, you’d use the exactly equal to “==” operator:

in a detail viewer (single record):


<?php if ($your_tableRecord['your_field'] == 'apples'): ?><h1>your field contains apples</h1>
<?php elseif ($your_tableRecord['your_field'] == 'bananas'): ?> <h1>your field contains bananas</h1>
<?php else: ?><h1>your field contains no apples or bananas</h1>
<?php endif ?>

And in a list viewer(multi record) :

<?php foreach ($your_tableRecords as $record): ?>
<?php if ($record['your_field'] == 'apples'): ?><h1>your field contains apples</h1>
<?php elseif ($record['your_field'] == 'bananas'): ?> <h1>your field contains bananas</h1>
<?php else: ?><h1>your field contains no apples or bananas</h1>
<?php endif ?>
<?php endforeach; ?>

Best,

Jerry Kornbluth

Hi Jerry,

Thanks for that it worked with the addition of <?php break ?>

But I think I'm trying to do this the wrong way because it grabs the first record when showing "ALL" types and if there are no records then it dos not show anything.

example - see red text: http://www.staging.baobabmarine.com/brokerage.php

changing the drop-down displays the three different types.

Is there a better way of doing this?

Hi there.

Thanks for posting!

Could you post a copy of that whole page you are working with? Best case scenario would be if you could attach the file instead of pasting code into a post.

I'll take a look at how you have things setup and see what options you have. I definitely think you are on the right track and Jerry's tips on if blocks was great.

Thanks!

Hi Ross, that's great, much appreciated. File attached.

Hi there.

I've been looking through that code and usually, if you just go to brokerage.php without any search criteria, it will display all your records. The only thing right now is that the link to this page on your site doesn't actually work anymore. Could you send me an up to date link?

Thanks!

Hi Ross, the site has gone live and is now at http://www.baobabmarine.com/brokerage.php - I have commented out the code so it does not show but its still viewable in the source.