Re: Looking for code for an alphabetic menu in php

Bill Mudry wrote:
> With the botanical wood tree that I have been working on, the number 
> of records for
> genera and for species can get quite large and unwieldy. Presently I 
> have over 6,000
> species records that takes a while to load let alone try to browse 
> through.
>
> I need to chop this up into querying by alphabet of the first letter 
> of the species
> botanical names. For the species level of organization, I have been 
> keeping the
> data in a MySQL file called simply 'species'. I want to have a single 
> character of the
> alphabet with each acting as a link for the first character of each 
> species name:
>         A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
> When a user click on one of them, it should be readable (eg. using 
> $_GET??) into a common variable for
> them all that can then be used for a select statement. The rest of 
> displaying the
> results in columns I already have working fine.
>
> What suggestions do you have for typical code that should work?
>
> Much thanks in advance,
>
> Bill Mudry
> Mississauga, Ontario, Canada 
Bill,

  I read this as you want the user to be able to select multiple letters 
to search on. If so I would recommend making each letter a checkbox. In 
your php code you would need to check each element in the $_GET or 
$_POST array. The SQL would then need to be:

SELECT species_name
    FROM species
    WHERE species_name LIKE 'b%'
    OR species_name LIKE 'g%'
    OR species_name LIKE 'r%';

Replace species_name with the correct column name.

Without resorting to some sort of client side scripting I am not sure 
you could select multiple letters to search on with simple HTML links.

Cheers,
James


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php