Code: Select all
$query="SELECT * FROM table where nidid=100";
$result=mysql_query($query, $link);
$num=mysql_numrows($result);
mysql_close($link);
<?php
$i=0;
while ($i < $num) {
$invoiced_activity_id=mysql_result($result,$i,"invoiced_activity_id");
$nidid=mysql_result($result,$i,"nidid");
$om_agreement=mysql_result($result,$i,"om_agreement");
?>
<TR>
<TD><?php echo $invoiced_activity_id;?></TD>
<TD><?php echo $nidid;?></TD>
<TD><?php echo $om_agreement;?></TD>
</TR>
<?php
$i++;
}
?>
ID#3 ...
ID#3 ...
ID#3 ...
ID#4 ...
ID#4 ...
ID#4 ...
ID#5 ...
ID#5 ...
ID#5 ...
I would like it to list each record only once.