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