Hello!
Tried to be as descriptive as possible in the title.
We have a one table, five field dbase with mysql and what I want is to display its contents on a website.
Now, I know the php to connect to the dbase etc, what I don't know is this:
How to make one field of all records of the dbase to display on a page alphabetically, as a link, which once you click, shows the whole entry in a fresh page.
More specifically, we are going to have a plant database comprising of one table and five fields(one of them an image). One of the fields will be the name of the plant. I want the name field of all records to show as a list, alphabetically sorted and as hyperlinks, which once you click on, it will show you, all the fields of that particular record.
Here is an example I found on another page: http://www.orchideenforum.de/kdb/index.php4
(Drop down list --> List of records arranged alphabetically as links --> Individual record)
Any help would be greatly appreciated.
Thank you.

Vasilis

Simplest way: Use an order clause in the query to get the plant list sorted alphabetically. get name and primary key for each, generate a link like get_plant.php?plant=primary_key, then get_plant.php can do a query for all the details.

Thank you for your reply.