How to highlight on a row & query?

ssun

I'm new at this. Help please!
I have a 3 table database in mysql. I'm using html & PHP for front end. What i'm trying to do is, Display all the data of one of the tables(i have done this), I want to highlight on one of the rows of data & query it to get that particular rows(person's)associated data from one of the other 2 tables. How do i highlight a row, Is there any function to do this?. Or is my whole approach to this wrong??

edwardsbc

How are you displaying the first table? For each row, you should be generating a hyperlink to a new script which which will show the data from the other tables based on which hyperlink the user selected. Something like this:

while(odbc_fetch_row($result)){
  $name=odbc_result($result,'name');
  $id=odbc_result($result,'id');
  echo '<tr><td>';
  echo '<a href="newscript.php?id='.$id.'">'.$name.'</a>';
  echo '</td></tr>;
}

This is using ODBC functions (which I'm more familiar with), but it is virtually the same using MySQL functions. The example assumes the result set has columns named name and id. I left out the table HTML.

In newscript.php you can then use the value of ID to either get the data you need.

ssun

Thanks!
This is how I am displaying my first table(no hyperlinks used)

<?while($row=mysql_fetch_array($result))
{
?>
<tr>
<td><?echo $row["personcode">];?></td>
<td><?echo $row["firstname"];?></td>
<td><?echo $row["lastname"];?></td>
<td><?echo $row["location"];?></td>
<td><?echo $row["phonenumber"];?></td>
<td><?echo $row["jacknumber"];?></td>
<td><?echo $row["division"];?></td>
</tr>
<?}?>