I have a MYSQL database and a table that contains 15 fields
After attaching to the database and displaying some of the fields uisng the following code: All the data in the database is being displayed in a "Do while if" statement.
<tr>
<td bgcolor="#00FF99"><font faces="Arial,Helvetica,sans-serif" size="2"><? echo $state;?><font></td>
<td><font faces="Arial,Helvetica,sans-serif" size="3"><? echo $name;?><font></td>
<td><font faces="Arial,Helvetica,sans-serif" size="2"><? echo $location;?><font></td>
<td><font faces="Arial,Helvetica,sans-serif" size="2"><? echo $dates;?><font></td>
<td><font faces="Arial,Helvetica,sans-serif" size="2"><? echo $type;?><font></td>
<td><font faces="Arial,Helvetica,sans-serif" size="2"><? echo $agegroup;?><font></td>
</tr>

I want the "State" field to be displayed as a link, so that when you click on it, it will call another "php" file that would display the other associated data.

Try this

<td><font faces="Arial,Helvetica,sans-serif" size="2"><? echo <a href=\"newpage.php?state=$state\">$state</a>;?><font></td>

Then run a query on the new page to pull the associated data

Ian

Thanks for your response. I think I understand what you want me to do. I forgot to mention that in the database there may be more than one entry for a "State" Example: Florida----->Data, Florida----->Data1, Florida----->Data3. Could I just pass the "Index" associated with the State to the othere "PHP" to pull the data for that particualr "State" being clicked???