$result=mysql_query("SELECT * FROM contact ORDER BY name",$connect);
is changed to:
$result=mysql_query("SELECT * FROM contact WHERE id='$dwnstrmid'",$connect);
then of course I only show notes when displaying $result:
echo $myrow['notes'];
I think the proble may in how I am callling the query, but it works when I display all data and not just for $dwnstrmid.
while($myrow=mysql_fetch_assoc($result))
Code: Select all
include "header.php";
$result=mysql_query("SELECT * FROM contact ORDER BY name",$connect);
echo "<table>";
while($myrow=mysql_fetch_assoc($result))
{
echo"<tr><td>";
$myrowї'dwnstrmid'];
echo $myrowї'notes'];
echo "</td>";
// Print the options to Read, Edit & Delete the Downstreams
echo "<td><a href="read_contact.php?dwnstrmid=$myrowїdownstrmid]">Notes</a>
|| <a href="edit_contact.php?dwnstrmid=$myrowїdwnstrmid]">Edit</a>
|| <a href="delete_contact.php?dwnstrmid=$myrowїdwnstrmid"> Delete</a></font></td></tr>";
}
echo "</table>";
?>- nirus