Code: Select all
$row = mysql_query("SELECT * FROM ". $regID ."") or die(mysql_error());
$num_rows = mysql_num_rows($row);
echo "Total Number of Items in this registry: ". $num_rows ."";
echo "<TABLE BORDER=1><TR><TH COLSPAN=7 ALIGN=left>Category: ". $row['category'] ."</TH></TR>";
// BEGIN SOME TYPE OF LOOP HERE
echo "<TR><TH>Item</TH><TH>Quantity Requested</TH><TH>Still Needs</TH><TH>Price</TH><TH>View</TH><TH>Quantity</TH><TH>Buy</TH></TR>";
// EXECUTE THIS LOOP (or some loop like it)
for($i=0; $i < $num_rows; $i++)
{
$row = mysql_fetch_array($row);
echo "<TR><TD>". $row['item'] ."</TD><TD>". $row['qty_req'] ."</TD><TD>". $row['still_needs'] ."</TD><TD>VAR price</TD><TD>VAR link</TD><TD>Input Field</TD><TD>Add to Cart</TD></TR>";
}
// UNTIL IT REACHES A ROW WITH A NEW NAME IN ITS 'product' COLUMN THEN END TABLE...
echo "</TABLE><br /><br />";
//DO THE WHOLE THING OVER AGAIN (back up to first loop)
// WHEN THE WHOLE THING IS COMPLETELY DONE, CLOSE DATABASE CONNECTION...
mysql_close($db);