hyperlinking or other table data

[rfigley]

I'm currently using this code to display data from table "tbl_chapter".

$query = ("select * from tbl_chapter");

$result = mysql_query($query) or die("Query fail");

if (mysql_num_rows($result) == 0)
{

} else
{

   echo "<B> Current Chapters List </B>";
     echo "<table border=1>";
  while($row = mysql_fetch_array($result))
    {
        echo "<P><B> " . $row['chapter_name'] . " - " .$row['county'] . "</B><BR> " . $row['lunch_breakfast'] . "<BR> " . $row['location'] . "<BR> " . $row['time'] . "<BR> " . $row['day'] . "<P>";
           }

}

I need to have the "chapter_name" field hyperlink to another table called 'tbl_members' who's "chapter_ name" is the same. So that clicking on it will take it to the page that displays those members; chapter_name_members.php.

[TodManPlaa]

HI,

Well first you have to amend your SQL statement so it pulls the records you want. I'd suggest a join where the two "chapter_name" fields are the same.

Then, once you have that working - you can pull out the field you want in the hyperlink (I'm assuming it is some ID number) just like how you pull out any other value.

Hope this helps

/s