The reset button only sets the form values back to it's previous values. It will not "reset" the record loaded on the page.
One way to "reset" the loaded record on the page is to add a redirect to the same page without the "?message_num=20". For example:

<input type="reset" value="Reset" onclick="location.href = '?';">

Since your form method is "GET", removing the "message_num" in the URL will deselect any messages.

i should have thought of the orderBy!

you can se the reset on the http://706aircadets.ca/weeklyMessage.php

> 1.  I have hard coded the "Weekly Messages" list to show in the file weeklyMessage.php.  However, it always displays the first message in the list, not the latest.  How can I get it to always display the latest first?

- You can use orderBy to sort the records, for example:

  list($_nlb_messagesRecords, $_nlb_messagesMetaData) = getRecords(array(
    'tableName'   => '_nlb_messages',
    'orderBy'     => 'sent_date DESC',
  ));

> 2.  For some reason the "Reset" button doesn't seem to work.  On the browser (Chrome), the button border turns blue when I click it (and stays that way), but no reset occurs.  Any ideas?

- Can you send me a link so I can take a look?

Thanks,

1.  I have hard coded the "Weekly Messages" list to show in the file weeklyMessage.php.  However, it always displays the first message in the list, not the latest.  How can I get it to always display the latest first?

2.  For some reason the "Reset" button doesn't seem to work.  On the browser (Chrome), the button border turns blue when I click it (and stays that way), but no reset occurs.  Any ideas?

Thanks!

Ragi

You're missing a ">" on your <option> tag:

<option value="<?php echo htmlencode($message['num']); ?>" <?php selectedIf($message['num'], @$_REQUEST['message_num']); ?>>

For displaying the messages, I'd check the values of $_nlb_messages first to confirm if it has any records in it and if the where clause that we added is correct by adding this code after the getRecords() function:

showme($_nlb_messages);

 And then I'd check if I'm looping through $_nlb_messages and display each records - pulling values from the correct array keys. The dropdown fields should take care of the filtering since you've already added the field and the where clause for '_nlb_messages'

Cheers,

Here is my code:

<?php include 'common/includes/php_header.inc'; ?>
<?php
  // error checking
  if (!@$GLOBALS['NEWSLETTER_BUILDER_PLUGIN']) { die("You must activate the newsletter plugin to see this page."); }

  // load newsletters settings and archives
  global $newsletterSettings;
  $newsletterSettings  = mysql_get('_nlb_settings', 1);
  $archivedNewsletters = mysql_select('_nlb_messages', "send IN ('all','archive') ORDER BY sent_date DESC");

  // load newsletter
    $whereMessageNumIs = 'TRUE';

if (@$_REQUEST['message_num']){
 $whereMessageNumIs = " num = '".mysql_escape($_REQUEST['message_num'])."'";
}

list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
  'tableName'   => '_nlb_messages',
  'loadUploads' => true,
  'allowSearch' => false,
  'where'    => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs,
//    'debugSql'            => true,
));

  // replace placeholders
  $archivedNewsletters = nlb_viewers_replacePlaceholders($archivedNewsletters);

?>


<table cellspacing="2" cellpadding="4">
 <tr>
  <td valign="top">

<?php if ($_nlb_messages): ?>
 <select name="message_num">
   <option value="">--</option>
   <?php foreach($_nlb_messages as $message): ?>
     <option value="<?php echo htmlencode($message['num']); ?>" <?php selectedIf($message['num'], @$_REQUEST['message_num']); ?>
       <?php echo htmlencode($message['subject']); ?>
     </option>
   <?php endforeach; ?>
 </select>
<?php endif; ?>
</td>
  <td valign="top">

    <b><?php echo htmlencode($message['subject']) ?></b><br/>
    <?php echo $message['html']; ?><br/>

  </td>

</tr>
</table>

'where'    => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs,

At the top of the file:

<?php include 'common/includes/php_header.inc'; ?>
<?php
  // error checking
  if (!@$GLOBALS['NEWSLETTER_BUILDER_PLUGIN']) { die("You must activate the newsletter plugin to see this page."); }

  // load newsletters settings and archives
  global $newsletterSettings;
  $newsletterSettings  = mysql_get('_nlb_settings', 1);
  $archivedNewsletters = mysql_select('_nlb_messages', "send IN ('all','archive') ORDER BY sent_date DESC");

  // load newsletter
    $whereMessageNumIs = 'TRUE';
    
if (@$_REQUEST['message_num']){
 $whereMessageNumIs = " num = '".mysql_escape($_REQUEST['message_num'])."'";
}

list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
  'tableName'   => '_nlb_messages',
  'loadUploads' => true,
  'allowSearch' => false,
  'where'    => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list'], '2')) . "' AND " . $whereMessageNumIs,
));

  // replace placeholders
  $archivedNewsletters = nlb_viewers_replacePlaceholders($archivedNewsletters);

?>

The dropdown & newsletter display:

<table cellspacing="2" cellpadding="4">
 <tr>
  <td valign="top">

    <b><?php echo htmlencode($message['subject']) ?></b><br/>
    <?php echo $message['html']; ?><br/>

  </td>
  <td valign="top">

    <h2>Weekly Message</h2>

<?php if ($_nlb_messages): ?>
 <select name="message_num">
   <option value="">--</option>
   <?php foreach($_nlb_messages as $message): ?>
     <option value="<?php echo htmlencode($message['num']); ?>" <?php selectedIf($message['num'], @$_REQUEST['message_num']); ?>
       <?php echo htmlencode($message['subject']); ?>
     </option>
   <?php endforeach; ?>
 </select>
<?php endif; ?>
</td>
</tr>
</table>

results:  a blank webpage (see attached).

I am trying o debug, but no clue so far.

> With the current dropdown, only the last message is displayed.

- This is because we're only getting one record as per this line:

$latestNewsletter = @$_nlb_messages[0]; // get first record

To display all the messages under the selected newsletter, you should loop through $_nlb_messages and display each record. Displaying the $latestNewsletter record will only display the latest record.

If you need a second dropdown for selecting which message to display, loop through $_nlb_messages and display each as <option> of a drop down select field. For example:

<?php if ($_nlb_messages): ?>
 <select name="message_num">
   <option value="">--</option>
   <?php foreach($_nlb_messages as $message): ?>
     <option value="<?php echo htmlencode($message['num']); ?>" <?php selectedIf($message['num'], @$_REQUEST['message_num']); ?>>
       <?php echo htmlencode($message['subject']); ?>
     </option>
   <?php endforeach; ?>
 </select>
<?php endif; ?>

And then add another clause to your 'where' statement to filter the results by  'num' of the selected message. For example:

$whereMessageNumIs = 'TRUE';
if (@$_REQUEST['message_num']){
 $whereMessageNumIs = " num = '".mysql_escape($_REQUEST['message_num'])."'";
}
list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
  'tableName'   => '_nlb_messages',
  //...
  'where'    => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs,
));

For readability, you might want to add the to_list filter to a where variable as well. For example:

$where = 'TRUE';
if (@$_REQUEST['to_list']){
 $where .= " AND to_list = '".mysql_escape($_REQUEST['to_list'])."'";
}
if (@$_REQUEST['message_num']){
 $where .= " AND num = '".mysql_escape($_REQUEST['message_num'])."'";
}
list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
  'tableName'   => '_nlb_messages',
  //...
  'where'       => $where,
));

Cheers,

For example, I have 3 lists, each of which currently has 2 messages.  With the current dropdown, only the last message is displayed.  I would like the user to choose which one to display.

P.S.  I just noticed that the following message gets printed on the webpage:

"category is selected!"

Not sure why.  Any ideas?

Sorry about the typo.

Can you try this to change the 'where' line to:

'where'    => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "'",

<?php include 'common/includes/php_header.inc'; ?>
<?php
  // error checking
  if (!@$GLOBALS['NEWSLETTER_BUILDER_PLUGIN']) { die("You must activate the newsletter plugin to see this page."); }

  // load newsletters settings and archives
  global $newsletterSettings;
  $newsletterSettings  = mysql_get('_nlb_settings', 1);
  $archivedNewsletters = mysql_select('_nlb_messages', "send IN ('all','archive') ORDER BY sent_date DESC");

  // load latest newsletter
  list($_nlb_messages, $_nlb_messagesMetaData) = getRecords(array(
    'tableName'   => '_nlb_messages',
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
    'where'    => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list'], '2')) . "'",
  ));
  $latestNewsletter = @$_nlb_messages[0]; // get first record
  if (!$latestNewsletter) { dieWith404("Couldn't find newsletter!"); } // show error message if no record found

  // replace placeholders
  $archivedNewsletters = nlb_viewers_replacePlaceholders($archivedNewsletters);
  $latestNewsletter    = nlb_viewers_replacePlaceholders($latestNewsletter);

?>

For some reason its not finding the newsletters.  It dies at the error message (in blue).

Any ideas?

P.S.  There are 3 templates & 6 newsletters in the queue.

If you need to be able to select which newsletter to display, you'll need a form with a dropdown list option for selecting a newsletter list. 

For example:

<?php
$newsLetterLists = mysql_select('_nlb_lists'); // mailing lists
?>

<?php if ($newsLetterLists): ?>
  <form method="get" action="?">
    <select name="to_list">
      <option value="">--</option>
      <?php foreach($newsLetterLists as $list): ?>
        <option value="<?php echo htmlencode($list['num']); ?>" <?php selectedIf($list['num'], @$_REQUEST['to_list']); ?>>
          <?php echo htmlencode($list['name']); ?>
        </option>
      <?php endforeach; ?>
    </select>
    <button type="submit" name="submitForm" value="1">Submit</button>
  </form>
<?php endif; ?>

Or a newsletter list menu:

<?php
$newsLetterLists = mysql_select('_nlb_lists');
?>

<?php if ($newsLetterLists): ?>
  <ul>
    <?php foreach($newsLetterLists as $list): ?>
      <li>
        <a href="?to_list=<?php echo htmlencode($list['num']); ?>">
          <?php echo htmlencode($list['name']); ?>
        </a>
      </li>
    <?php endforeach; ?>
  </ul>
<?php endif; ?>


And then change this line:

'where' => " to_list = 1 ", 

To:

'where' => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list'), '2') . "'",


Note: the coalesce() function works like MYSQL COALESCE which returns the first argument if the first argument is true(if exist), and will return the last argument if false. In the example above, if the user haven't selected a 'to_list', 'to_list' num 2 will be displayed. Kinda works like the to_list num 2 is the default list to display.

And for adding more filters, you can add more fields in the form and update the 'where' value base on the new fields.

Cheers,

Now the archive.php file will only display the latest newsletter from the list I wanted to display.  I have attached the basic file I am using.

So, two issues:

(1)  I still need to be able to pick and choose which newsletter I want to see from the list; and

(2)  the list of newsletters need to be somehow filtered so that I only see the pertinent newsletters.

Make sense?

Ragi

If you're talking about the "Newsletter Archive" viewer page then that's exactly what we're doing on our page here:
https://www.interactivetools.com/news/archive.php?145

We've got multiple newsletters: Our main newsletter, our beta announcements list, etc. 

What we do is just filter on the 'to_list' field Tim suggested, but in the viewer code, something like this:

'where' => " to_list = 1 ", 

Let me know if that works for you.

Wouldn't it be easiest to set up the search for the editor, something like 

Subscriber List|to_list|match

Then at the tope of the page, they just select which group to display?

Is there an easy way to do that?

Ragi