hi guys, please help as i said all the boxes post the datato the database except one ($proddesc):
PHP Code:
<?php
include("db.php");
$servicecentre=$_POST['servicecentre'];
$ponumber=$_POST['ponumber'];
$prodcode=$_POST['productcode'];
$proddesc=$_POST['productdescription'];
$price=$_POST['price'];
$qty=$_POST['quantity'];
$total=$_POST['total'];
mysql_query("INSERT INTO purchaseorder (servicecentre,ponumber,productcode,productdescription,price,quantity,total) VALUES ('$servicecentre','$ponumber','$prodcode','$proddesc','$price','$qty','$total')");
header("location: tableedit.php#page=addpro");
?>
HTML Code:
<div class="content" id="addpro">
<form style="text-align:right"action="saveproduct.php" method="post">
	<div style="width:400px; text-align:right">
    <div style="margin-left: 48px;">
	Service Centre: <input name="servicecentre" type="text" />
	</div>
	<br />
	<div style="margin-left: 97px;">
	PO Number: <input name="ponumber" type="text" />
	</div>
	<br />
	<div style="margin-left: 80px;">
	Product Code: <input name="productcode" type="text" />
	</div>
    <br />
	<div style="margin-left: 80px;">
	Product Description:  <input name="proddesc" type="text" />
	</div>
    <br />
	<div style="margin-left: 80px;">
	Price:  <input name="price" type="text" />
	</div>
    <br />
	<div style="margin-left: 80px;">
	Quantity: <input name="quantity" type="text" />
	</div>
    <br />
	<div style="margin-left: 80px;">
	Total: <input name="total" type="text" />
	</div>
	<div style="margin-left: 127px; margin-top: 14px;"><input name="" type="submit" value="Add" /></div>
</div>
</form>
</div>
thanks in advanced