Edit Transaction

[erros]

Form No. 1

 

Form No.2

 

hi all, i have a problem to make edit condition, the picture shows when user input the produk, they just fill in qty collumn and get total and point result.

 

and user save transaction and display like form no .2

 

and then my problem is, how to make edit condition, if user click the edit button in form no.2, and return display like form no.1 with data for each collumn. thanks.

[trampolinejoe]

hello,

 

you need to make a new file,

 

open your db at the top, then set all your variables.

 

prefill the pages values with the correct details,

then have a update button which re-submits to the db and updates the details.

 

<?php 

 include 'opendb.php';
 $customernumber =  $_GET["customernumber"];


	$result = mysql_query("SELECT * FROM orders WHERE customernumber = " . $customernumber);

	while($row = mysql_fetch_array($result))
	  {
			  $connote =  $row['connote'];

             } ?>

<form name="form1" method="post" action="update.php?customernumber=<?php echo "$customernumber" ?>" >

    <input type="text" name="price" value="<?php echo "$price"; ?>" >

    <input type="submit" name="Submit" value="Update">
    
</form>

 

 

Cheers,