search on filtered page with pagination

desertdirk

HI
I have a record set that displays contacts on a page one record at a time. The next, previous, first, last work fine. What I want to be able to do is jump to a record using a drop-down menu which displays the last name of all the contacts in the record set.

So if I am looking at record 12 of 25, Jones, John- I want to pull down a menu that has all the last names so that I can select Williams, Bill and jump to that record.

How can this be done?

Will post code if needed.
DD
Thanks

ccgorman

It looks like you need to use some JavaScript. What you will want to do is add an onChange command to your dropdown, for example:

<form name="search" action="./" method="post">
<select name="lastname" onChange="movePage()">
<option value="Jones">Jones</option>
</select>
</form>

in the html you will need to add anchors, for example

<a name="Jones"></a>Jones, Fred<br>
Jones, Martha<br>
<a name="Henitoot"></a>Henitoot, Fred<br>

then all you need to do is the JavaScript function which would be something like this:

function movePage() {
var item = document.forms['search'].elements['lastname'].selectedIndex;
var choice = document.forms['search'].elements['lastname'].options[item].value;
document.location="./#"+choice;

not sure of the last line, you may need the absolute URL

desertdirk

Thanks for taking time to do that. Since the resulting list is over 2000 names I can't do an anchor unless I can anchor a global variable?

here is the code that is used in the select menu:

  <select name="selfullname" size= "3" id="selfullname">
        <?php
do {  

?>
        <option value="<?php echo $row_update['FullName']?>"><?php echo $row_update['FullName']?></option>
        <?php
} while ($row_update = mysql_fetch_assoc($update));
  $rows = mysql_num_rows($update);
  if($rows > 0) {
      mysql_data_seek($update, 0);
	  $row_update = mysql_fetch_assoc($update);
  }
?>
      </select>

the variable $update is the result of the mysql query, after the limit has been set to 1 (to display one page at a time) Is there a way to un-limit the query, so that the array returns all rows?

I have tried using a seperate query, but that runs very slow on th e page.

Thanks
dd