Hi guys (Again),

I have tried to figure it out my self before posting (books, google etc) but cant really find anything that helps me;

What I am trying to do is for the staff to type in a product number text box (number already in database (table 1)) and echo the product description in one box called "product description" another textbox with the price so the form can be posted to the database (table 2) along with the added "Purchase order number, quantity and total"

but for the life of me i cannot get it to work,

Heres the PHP please dont laugh at the code as i am still learning PHP:

PHP Code:
<?php
    
    
include ("db.php");
    
    
$prodsearch1 mysql_real_escape_string($_POST['productcode']);
    
$prodfind mysql_query("SELECT productdescription FROM products WHERE productcode = '".$prodsearch1."'");
    (
$row5 mysql_fetch_array($prodfind)); $row5 $row5['productcode']; 
    
   
?>
and the html:

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" value="<?php echo $row5 ?>"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="Save" /></div>

</div>
</form>
</div>
Thanks in advanced and for your patience