Addition of values in database

Kayosz · June 22, 2007

Hi all,

Need a bit of help here.

In my database I have two products. Each product is made up of components. This is the product table:

ProductID Description

--------- -----------

1 Timer

2 Strobelight

This is the components table:

ComponentID Parttype

------------ -----------

1 20K resistor

2 Strobelight

This is the compperprod table:

CPPID ProductID ComponentID Quantity

------ ---------- ------------ --------

1 1 1 2

2 2 1 5

3 2 2 1

As you can see from the above table product 1 and product 2 shares the same component namely the 20K resistor.

What I am trying to achieve here is when I request a quantity of 5 for product 1 and a quantity of 3 for product 2, it must multiply all the components of product 1 with 5 and all the components of product 2 with 3. Where products shares the same components it must take the multiplied values and add them together.

This is my code that send the product quantities to another page.

<html>
<head><link type="text/css" href="stock.css" rel="stylesheet"></head>
<body bgcolor="#ffffff" topmargin="0" leftmargin="0">
<table>
<?php
include ("dbconnect.php");
require ("emreg.php");
?>	
</table>
<form name="stocktake" method="post" action="productcalculation.php">
<table align="center" width="100%" cellpadding="1" cellspacing="0" border="0" bgcolor="white">
<tr><td colspan="2"><hr size="1" color="#778899"></td></tr>
<tr>
<td align="center" valign="top">
	<table width="50%" cellpadding="0" cellspacing="0" border="1" bordercolor="#004080">
		<tr align="center" bgcolor="#004080">
			<td width="30%"><font class="tblhdr">Parttype</font></td>
			<td><img src="images/spacer.gif" width="12" height="20" border="0"></td>
			<td width="30%"><font class="tblhdr">Description</font></td>						
		</tr>
		<tr>
			<td colspan="15">					
				<table id="componentList"  cellpadding="0" cellspacing="1" border="0" width="100%" style="CURSOR: hand">
				<?php
				$productQuery = mysql_query("SELECT ProdID,Description FROM products");

				while ($row = mysql_fetch_assoc($productQuery)) {		
						echo "<tr align=center>"; 
						echo "<td width=30% class=tableData>".$row['Description']."</td>";
						echo "<td width=10% class=tableData><input type=text name=ProdID".$row['ProdID']." value=0 size=5></td>";
						echo "</tr>";							
					}
				?>
				</table>					
			</td>						
		</tr>
	</table>
</td>	
</tr>
<tr>
<td valign="top" align="center"><input type="hidden" name="action"><input type="submit" name="btnUpdate" value="Request"><?php echo $msg; ?><br></td>		
</tr>
</table>
</form>
</body>
</html>

How do I code this?

Sign In

Addition of values in database

Recommended Posts

Kayosz

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information