WHILE function repeating too many times
Posted: Mon Nov 30, 2009 4:20 pm
I am trying to fill in 3 rows with data retrieved from a table. With my code below, each record is successfully retrieved and displayed, however, each is repeated three times.
(Incorrect) Output:
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.
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.