Jump to content

approve button inside while loop


Recommended Posts

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>


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...