Firstly thank you for this, I appreciate it. I have tested this and it works as long as the date is in the past, however if the time is in the past, it still remains visible.

So for example, I set the removeAfter date to yesterday and everything works perfectly. I change the removeAfter to today but a few minutes into the past and it does nothing. 

Any thoughts?

I'm trying to do exactly the same as this but with the removeDate as well:
https://www.interactivetools.com/forum/forum-posts.php?postNum=2244283#post2244283

I'm only wanting certain content in the page to be hidden. If I use just the 'hidden' or 'removeDate', then I'm left with a white screen showing "Record not found!". 

If it's of any assistance, I'm using more than one section editor on this screen. 

I have the  checkbox working fine the following:

'tableName'   => 'bhs_promo',
'where'    => " hidden = '0' ", 
'orWhere'    => " hidden = '1' ",
'loadUploads' => true,
'allowSearch' => false,
'limit'       => '1',

<?php foreach ($bhs_promoRecords as $record): ?>
<?php if ($record['hidden'] == '0' ||  $record['hidden'] == ''): ?>
Content here...
<?php endif ?>
<?php endforeach ?>

I have no idea how to include the 'removeDate' field syntax? 

Thank you

So I've basically moved all website files and database over to a new hosting provider. 

1. When I try login using the correct login details, it reloads the page as if to log me in but doesn't. If I then click the "website name" on the left of the login fields it re-directs me into the system. Sometimes I don't even have to login, I just click the name and it allows me access. Logout doesn't seem to work at all.

2. I've tried clearing the database completely and doing a fresh install - same issues occur.

3. When I add/edit content it seems to write to the database correctly and tells me it saves correctly in CMS Builder, but doesn't seem to actually save the changes or show those changes on the website. 

4. Haven't seen any error messages at all. 

Kind regards
Shawn

I recently had to move a website from one hosting provider to another. Since setting everything up again, I'm experiencing some issues like:

- Logging in issues
- Reading / writing to database issues

Can I perhaps send details to someone who can possibly check that everything is correctly setup?

Kind regards

Shawn

I'm having a similar issue. When I try update and save a section editor, I get the following "There was an error sending the request! (403 Forbidden)"...

Kindly advise?

I am listing events which use the 'removeDate' field to expire the event. I'm also using <? echo mysql_count('events','');?> to show a count of the events.

Unfortunately, what is happening is that the count is still showing events that are expired because they aren't completely removed from the database.

Can you assist on this?

Thank you

Shawn

Thank you for the reply. Not sure what you mean exactly? It's just a checkbox field type with fieldname "popular". The table name is 'tableName'   => 'listing',

Popular (value): <?php echo $record['popular'] ?>
Popular (text):  <?php echo $record['popular:text'] ?>

I have a muli-list called "city".

 City (value): <?php echo $record['city'] ?>
 City (label): <?php echo $record['city:label'] ?>

So I basically I'm filtering my listings: 'where' => "city = 'CT'", and would like to know which over those listings in "CT"are checked as "Popular".

At the moment I can return a count for all listings checked as popular like this, but only want those 'where' => "city = 'CT'"

<? echo mysql_select_count_from('listing','popular');?>

list($listingRecords, $listingMetaData) = getRecords(array(
    'tableName'   => 'listing',
    'where' => "city = 'CT'",
  ));

This is giving me the record count of all listings checked "Popular".

<? echo mysql_select_count_from('listing','popular');?>


I want to know how many listings are checked popular for the City = "CT"...

Any assistance greatly appreciated.

So what I need to do now, is somehow use the "createdDate" field name and after a certain time automatically set the checkbox to unchecked. Any help?

Sadly my php knowledge is non existent. I'm more on the design and front end side. So any help doing something would be great.

Kind regards

Shawn

Thank you,
Shawn