hi,
did anyone know how to create header detail transaction form in one
page and input it on the database?
for example that i created in php :
=== form_input_tr_pr.php ===
<form name="PRForm" method="post" enctype="multipart/form-data"
action="input_tr_pr.php">
<table>
<tr>
<td align="center">Stock ID</td>
<td align="center">Quantity</td>
</tr>
<tr id="rowID1">
<td>
<div align=center>
<select size=1 name=stock_id_1>
<option>-select-</option>
<?php
tambah();
?>
</select>
</div>
</td>
<td>
<input type=text name="quantity_1" size="12"
maxlength="9"/>
</td>
</tr>
</table>
<table>
<tr>
<td align="right">
<input type=submit value=Save title="Input Surat Order
Pengeluaran Barang" />
<input type="reset" value="Clear" title="Clear All
Data" />
</td>
</tr>
</table>
</form>
=== input_tr_pr.php ===
<?php
include ('../../connectdb.php');
$date = date ("Y/m/d");
$numresults = mysql_query ("SELECT * FROM tr_pr_header WHERE date =
CURRENT_DATE()");
$numrows = mysql_num_rows ($numresults);
$no = $numrows + 1;
$statement = mysql_query ("INSERT INTO tr_pr_header (pr_no, date)
VALUES ('CA/PR/$date/$no', NOW())");
$statements = mysql_query ("INSERT INTO tr_pr_detail (pr_no, stock_id,
quantity) VALUES ('CA/PR/$date/$no', '$stock_id', $quantity)");
header ("location:view_tr_pr.php");
?>
any hints, suggestion is well appreciate, thank you so much before