Here is my code:
/ check for related Product Group /
$pg_query = "select from tbSubAppLProdGrp where fkSubApp = '$pkSubApp'";
$pg_query_result = mysql_query($pg_query, $mysql_link);
$pg = mysql_fetch_object($pg_query_result);
if ($pg){
$fkProdGrp = $pg->fkProdGrp;
/ is the ProdGrp a noshow? /
$ns_query = "select from tbProdGrp where pkProdGrp = '$fkProdGrp'";
$ns_query_result = mysql_query($ns_query, $mysql_link);
$ns = mysql_fetch_object($ns_query_result);
$NoShow = $ns->NoShow;
if ($NoShow == ''){
print "<a href=\"ProdGrps.html?fkApp=$fkApp&fkSubApp=$fkSubApp\"><b>$Title</b></a><br>\n";
print "$Description\n";
print "<p>\n";
}
}
How do I get it to print only once, not once for each pkProdGrp??
Thanks!!!
