how do I create a self populating filter list

<?php
  // load records from 'literary_corner'
  list($literary_corner_dropdown, $literary_corner_dropdownMetaData) = getRecords(array(
    'tableName'   => 'literary_corner',
    'loadUploads' => false,
    'allowSearch' => false,
  ));
?>


<form action="./" action="get">
  <select name="author_name">
    <?php foreach ($literary_corner_dropdown as $record): ?>
      <option value="<?php echo urlencode($record['author_name']) ?>">
        <?php echo htmlencode($record['author_name']) ?>
      </option>
    <?php endforeach ?>
  </select>
  <button type="button">Submit</button>
</form>


Hi Mizrahi,

Thanks for that, it is appreciated, I took your code and placed the first part before the head section of my php page and the form part in the body, I got a code error  which looks as though it was related to <form action="./" action="get">  I wasnt't sure if I was supposed to change whatever was between the " "  but looked at a similar type of form and replaced the form action line with  <form method="post" action="literary_list.php"> which I assumed would just post the search results back to the same page. This got rid of the error however although the drop down list populates and I can select different authors nothing happens when I hit the submit button, the page doesn't refresh and the content doesnt change. I am obviously missing something here but cannot understand what.

I have checked the variable names and they seem fine so am at a loss to understand why it doesn't work I assume it may have something to do with the form action element but need some help to understand what. It seems as though the page doesn't understand what it should be doing when the submit button is pressed if that makes sense.

Thanks again for your help.

Can you post your full page code?

Due to the time difference i am not in the office at the moment, i will post the page for you tomorrow if thats okay.

steve

Hi,

Here is my current listing file. hope it helps. In case it is relevant all my cmsb listing and detail pages are in a subdirectory off the route folder called listings.

As an update to this I have re-thought how the section is constructed and have now been able to produce a working filter.

Thanks for your help.