here is my code:
if(mysql_affected_row() != 0)
{
print("<SCRIPT LANGUAGE=\"JavaScript\">
if(confirm(\"This Company Already Has A Backorder For This Products. Add To Quantity?\"))
{
//If Confirm = Yes then I want to Update bQty How do I do this
<?
$query = "update backordersmain set bQty = '$new_qty' where bItemNumber = '$bItemNumber' ANd bCustId = '$bCustId'";
$mysql_result = mysql_query($query, $mysql_link);
?>
url = \"./addBackorders.php\";
window.location.href = url;
}
else
{
url = \"./addBackorders.php?addBackorder=Second&bQty=$bQty&bItemNumber=$bItemNumber&bCustId=$bCustId&bCancelDate=$bCancelDate&bEnterDate=$bEnterDate&bStatus=open\";
window.location.href = url;
}
</script>");
}