newphpcoder Posted April 19, 2012 Report Share Posted April 19, 2012 Hi...I have form which data is inside while loop and per row has a approved button, Now I have no idea that when I click the approve button the JO # from that row will display and save to the database.here is my code and sample form. <?php error_reporting(0); date_default_timezone_set("Asia/Singapore"); //set the time zone $con = mysql_connect('localhost', 'root','');if (!$con) { echo 'failed'; die();}mysql_select_db("mes", $con);$Date_Shelve =date('Y-m-d H:i:s'); ?><html><head><title>Sales Order</title><link rel="stylesheet" type="text/css" href="kanban.css" /> </head><body><form name="loading_kanban" action="" method="post"><div id="SR_date"><label>Date :</label><input type="text" name="Date_Shelve" id="Date_Shelve" value="<?php echo $Date_Shelve; ?>" size="16" readonly="readonly" style="border: none;"> </div><div id="kanban_table"><table><th> JO No.</th><th> ETD </th><th> PO No. </th><th> SKU Code </th><th> Description </th><th> PO Req </th><th> Requirements </th><th> Priority</th><?php$sql = "SELECT ETD, PO_No, SKUCode, Description, POReqFROM sales_order";$res_so = mysql_query($sql, $con);while($row = mysql_fetch_assoc($res_so)){$ETD = $row['ETD'];$PO_No = $row['PO_No'];$SKUCode = $row['SKUCode'];$Description = $row['Description'];$POReq = $row['POReq']; echo "<tr><td> </td><td>$ETD</td><td>$PO_No</td><td>$SKUCode</td><td>$Description</td><td>$POReq</td><td> </td><td><input type='button' name='priority' value='Approved' id='priority'></td></tr>";}?></table></div></form></body></html> JO.doc Link to comment Share on other sites More sharing options...
birbal Posted April 19, 2012 Report Share Posted April 19, 2012 you want to do that dynamicaly? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now