Not Looping...
| From: | WreckRman2 | Date: | Thu, 15 Mar 2001 07:18:38 +0000 |
| Subject: | Not Looping... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-43982@lists.php.net to get a copy of this message | ||
I am having problems figuring out how to loop to show more then one
record... Any help would be great... All I can get is the first record...
Thanks...
Code:
<?php
$db = mysql_connect("localhost", "root", "*****");
mysql_select_db("indywebdesign",$db);
$invoices_result = mysql_query("select * from invoices WHERE customerid=$id
ORDER BY invoiceid DESC");
$invoices = mysql_fetch_array($invoices_result);
?>
<TR>
<TD BGCOLOR="#EAEAEA"><FONT FACE="Tahoma"
SIZE="2"><?php echo
$invoices["date"] ?></FONT></TD>
<TD BGCOLOR="#EAEAEA"><FONT FACE="Tahoma"
SIZE="2"><?php echo
$invoices["amount"] ?></FONT></TD>
<TD BGCOLOR="#EAEAEA" COLSPAN="2"><FONT FACE="Tahoma"
SIZE="2"><?php
echo $invoices["description"] ?></FONT></TD>
</TR>