newphpcoder Posted April 19, 2012 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 Share Posted April 19, 2012 you want to do that dynamicaly? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.