abujuguluy
Addict
- Joined
- Aug 4, 2014
- Posts
- 22
- Reaction
- 1
- Points
- 71
- Age
- 27
Hello po mga sir magandang umaga, patulong naman po sa code ko di ko kasi mapagana.
Ang dapat kasi na mangyari e bago maging clickable ung Confirm Order e dapat ma update muna nung admin ung sales invoice number na nasa table, ang problema ko di nag uupdate ung sales_invoice_number.
Eto naman ung get_sir.php code ko
Code:
<tr>
<td><?php echo $product_row['name']; ?></td>
<td><?php echo $member_row['Firstname']." ".$member_row['Lastname']; ?></td>
<td><?php echo $cart_row['price']; ?></td>
<td><?php echo $cart_row['qty']; ?></td>
<td><?php echo $cart_row['total']; ?></td>
<td><?php echo $cart_row['status']; ?></td>
<td><?php echo $cart_row['modeofpayment']; ?></td>
<form action="update_sir.php" method="get">
<td ><input type="text" name="sales_invoice_number"> <input type="submit" value="Confirm"></td>
</form>
<td><?php echo $cart_row['date'];?></td>
<td width="140"><a href="update_status.php<?php echo '?id='.$order_id; ?>" class="btn btn-success"><i class="fa fa-check"></i> Confirm Order</a></td>
</tr>
Ang dapat kasi na mangyari e bago maging clickable ung Confirm Order e dapat ma update muna nung admin ung sales invoice number na nasa table, ang problema ko di nag uupdate ung sales_invoice_number.
Eto naman ung get_sir.php code ko
Code:
<?php
include('connect.php');
$sir = $_GET["sales_invoice_number"];
mysql_query("update order_details set sales_invoice_number ='$sir' where orderid='$get_id'")or die(mysql_error());
header('location:orders.php');
?>