J
|
Jane 12/12/2006 |
Jake,
where FieldID is the foreign key in the SCRAP table. global $conn; $strdetail = "select * from SCRAP_NOTES where FieldID=".$value; $rsdetail=db_query($strdetail,$conn); $datad=db_fetch_array($rsdetail); if ($datad) $value="<a href=\"SCRAP_NOTES_list.php?mastertable=SCRAP&masterkey1=".$value."\">SCRAP_NOTES</a>"; else $value=""; |
J
|
Jkelleyus author 12/12/2006 |
Thnaks, Jane... That worked well but I think I'm going to try another approach to this. |
J
|
Jane 12/13/2006 |
Jake, global $conn; $strdetail = "select count(*) from SCRAP_NOTES where FieldID=".$value; $rsdetail=db_query($strdetail,$conn); $datad=db_fetch_numarray($rsdetail); if ($datad[0]>0) $value="<a href=\"SCRAP_NOTES_list.php?mastertable=SCRAP&masterkey1=".$value."\">".$datad[0]." SCRAP_NOTES</a>"; else $value=""; |
J
|
Jkelleyus author 12/13/2006 |
Sorry... I wasn't clear at all. |
J
|
Jane 12/14/2006 |
Jake, if ($value) $value="Notes Exist"; else $value="No Notes"; |