Combining option values before form submission

Hi Jerry,

What about doing something like this:

  if(@$_REQUEST['month'] && @$_REQUEST['year']){
    $_REQUEST['attended_keyword'] = $_REQUEST['month'].'-'.$_REQUEST['year'];
  }


So if both the year and month fields have been submitted, they are combined into a request array called attended_keyword. You need to make sure that your getRecords function appears after this code, and that search is set to true. I also made a couple of changes to your form as well:

<form method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>">
  <?php
  $lowestYear = 2000;
  $highestYear = date("Y");
  ?>
  Month:
  <select name="month">
    <?php foreach(range(1,12) as $month): ?>
      <?php $timeValue = strtotime("2012-$month"); ?>
      <option value="<?php echo date("m",$timeValue);?>"><?php echo date("F",$timeValue);?></option>
    <?php endforeach ?>
  </select>
  Year:
  <select name="year">
    <?php foreach (range($highestYear,$lowestYear) as $year):?>
      <option value="<?php echo substr($year, -2);?>" ><?php echo $year;?></option>
    <?php endforeach?>
  </select>
  <input type="submit" name="submit" value="Search">
</form>

Before there was a '-' at the beginning of the year value which I've removed. I've also changed the month foreach loop so that it only creates the strtotime value once. 

Let me know if you have any questions.

Thanks!

Greg

Thanks Greg,

I'll give it a go in the morning.

Jerry Kornbluth

Hi Greg,

The attached, based on your suggestion works perfectly, but I need to be able to show the alpha values in the “salons to display” options instead of the original record number values.

Let me explain further.

My “salon_name” field is a multi value check box list field that gets it’s option values from the “num” field and it’s label values from the “title” field in a database called “salon_names”.

At present, I’m creating an array of all unique values in the salon_names field, and using those values to determine my search criteria. The searches work, however they display the numerical values in the “salons to display” list, and I can’t seem to get them to display the alpha values.

I tried mucking about with this numToName  function that I used in another application, but couldn’t figure out how to modify it to work here.
 

<?php   
$numToName = array();
foreach ($master_exhibition_listRecords as $record){
  $numToName[$record['num']] = $record['title'];
}
?>

I’ve attached the current search form so you can see exactly what’s going on.

Thanks,

Jerry Kornbluth

Thanks Greg,

I'll give it a go.

Jerry Kornbluth