Well i got referred over here by the asp forum. What i am trying to do is to use my excel database of fish and info about them (Which can be converted to access if need be).
The columns would be (Phylum, Family, Genus, Species, PIcture Number) for instance.
I want to set this up in a series of drop-down boxes, and search forms so that it looks like this.
[Drop down box with choices of Phylum]
[Drop down box of the choices of families within that Phylum]
[Drop down box of Genuses in that Family]
[Drop down box/or search box of the species in that genus]
After a species is selected, I want it to pop up with all of the corresponding information on it (IE, its latin name, where it is located , what GPS coordinates it was found at, and on the right, I want a picture of it to pop up) I can sort the pictures in any way, I just don't know how to approach it.
//if($link_id)echo "connection created";
$sql="select * from test1";
//if($result)echo "record retrieve successfully";
<!-- table heading-->
<table summary="heading" bgcolor="#ffccff" border="1" width="100%">
<td width="20%" align="left"><th>Phylum</th></td>
<td width="20%" align="center"><th>Family</th></td>
<td width="20%"><th nowrap>Picture Number</th></td>
<!--form fror display data to select-->
<!--display.php page will open when you will select any option-->
<form action="display.php" method="post" >
<table summary="data of table" bgcolor="#ffcccc" border="0"
<tr><td width="20%" >
<option value="<? echo $data['Phylum']?>"><? echo $data['Phylum'];?></option>
<input type="submit" value="show information">
here is display.php
echo "on selection no 1 what you want to display.";
echo "on selection no 2 what you want to display.";
echo "on selection no 3 what you want to display.";