Hi, This might be more appropriate in the PHP section, I'm not sure - still a newb.
I have read this problem in other threads, but can't seem to make the solutions work for me. I have a table that shows the results of a query for either pat_id or surname. I want the user to be able to click on a hyperlink of pat_id (there might be many rows) and for that pat_id to be sent to another php page that shows the related information for that patient ONLY.
Here is my code so far, at the moment the hyperlink goes to www.yahoo.com. I don't want to send the pat_id variable via the URL (ie a $_GET method) as I need it to be private.
<?php
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . "<a href=\"http://www.yahoo.com\">" . $row['pat_id'] . "</a>" . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['middlename'] . "</td>";
echo "<td>" . $row['surname'] . "</td>";
echo "<td>" . $row['dob'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['sex'] . "</td>";
echo "<td>" . $row['phone'] . "</td>";
echo "<td>" . $row['phone_alt'] . "</td>";
echo "<td>" . $row['address'] . "</td>";
echo "<td>" . $row['hospital'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>