Display Button for more if paid record

3 posts by 2 authors in: Forums > CMS Builder
Last Post: December 4, 2009   (RSS)

By Liz1001 - December 4, 2009

I have one more question. There are two types of listing - paid and free. The free listing should not display a button to 'view more' however the paid listing should.

I added a field to the database called 'level' if the box is checked then they have paid. I am using the following code to display the 'More Information' button but not having much luck, could you see if I missed something obvious or am going about this the wrong way - really appreciate your help!

<!--Show More info Button if paid listing-->
<?php foreach($business_listingRecords as $record); ?>
<?php if ($record['level'] =='1'): ?>
<a href="<?php echo $record['_link'] ?>"><img src="images/more_information.jpg" width="109" height="26" hspace="40" vspace="10" /></a>
<?php elseif ($record['level'] == '0'): ?>
<?php echo 'Sign Up' ?>
<?php endif ?>

Also, I need to talk to someone to cost out how much it would be to have you guys make the form at http://mormonbusiness.com/submit-a-business.php dynamic so it automatically places the form fields into the database record.

Thanks
Liz

Re: [Liz1001] Display Button for more if paid record

By Dave - December 4, 2009

Hi Liz,

It looks right, but for records that were created _before_ you added that field they'll have a value of null (or blank) for "level". You can actually just test the variable by itself to see if it contains a value that isn't zero or blank. Try this instead:

<?php if ($record['level']): ?>
<a href="<?php echo $record['_link'] ?>"><img src="images/more_information.jpg" width="109" height="26" hspace="40" vspace="10" /></a>
<?php else: ?>
Sign Up
<?php endif ?>

If that doesn't work, have a look to see what the value is for level with this debugging code:
Level value is '<?php $record['level'] ?>'<br/>

Let me know if that works for you!
Dave Edis - Senior Developer
interactivetools.com