I have a table where I'm trying to display all rows where field5="Brand One". For some reason it's printing the same row over and over instead of the different rows. In other words it's doing this:
1/1/2012 A Bob Smith $3.99 Brand One
1/1/2012 A Bob Smith $3.99 Brand One
1/1/2012 A Bob Smith $3.99 Brand One
1/1/2012 A Bob Smith $3.99 Brand One
INSTEAD OF:
1/1/2012 A Bob Smith $3.99 Brand One
1/4/2013 B John Smith $4.99 Brand One
1/7/2013 C Bob Johnson $6.99 Brand One
1/8/2013 Q George Smitherson $8.99 Brand One
<?php
$username="XXXX";
$password="XXXX";
$database="XXXX";
$servername="XXXX";
mysql_connect($servername,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM `list` WHERE Field5 = 'brand one'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
Brand One:
<table>
<?php
$i=0;
while ($i < $num) {
$list_result1=mysql_result($result,0,"field1"); //Date
$list_result2=mysql_result($result,0,"field2"); //Letter
$list_result3=mysql_result($result,0,"field3"); //Name
$list_result4=mysql_result($result,0,"field4"); //Price
$list_result5=mysql_result($result,0,"field5"); //Brand
?>
<tr><td><?php echo $list_result1; ?></td><td><?php echo $list_result2; ?></td><td><?php echo $list_result3; ?></td><td><?php echo $list_result4; ?></td><td><?php echo $list_result5; ?></td></tr>
<?php
$i++;
}
?>
</table>
Any ideas?? :-)
