Update não funciona

[jfreitas]

Pessoal,

O update simplesmente não funciona.... Alguém pode me ajudar?

$sql = 'SELECT
ordd.order_number,
prodd.name as product_name,
ordd.amount,
ord.un,
ordd.desconto,
IF(ordd.desconto >0, (ordd.amount*(ordd.price-ordd.desconto)),(ordd.amount*ordd.price)) as units_total_price,
ordd.price as unit_price,
products.sku,
ordd.id,
products.icon_thumb
FROM '.TABLE_ORDERS_ORCAR_DESCRIPTION.' ordd
INNER JOIN '.$this->tableName.' ON ordd.order_number = '.$this->tableName.'.order_number
INNER JOIN '.TABLE_PRODUCTS_DESCRIPTION.' prodd ON ordd.product_id = prodd.product_id
INNER JOIN '.TABLE_PRODUCTS.' products ON ordd.product_id = products.id
INNER JOIN '.TABLE_ORDERS_ORCAR.' ord ON ord.order_number = ordd.order_number
LEFT OUTER JOIN '.TABLE_CURRENCIES.' cur ON '.$this->tableName.'.currency = cur.code
LEFT OUTER JOIN '.TABLE_CUSTOMERS.' cust ON '.$this->tableName.'.customer_id = cust.id
WHERE
'.$this->tableName.'.'.$this->primaryKey.' = '.(int)$oid.' AND
prodd.language_id = \''.$language_id.'\' ';
if($this->customer_id != ''){
$sql .= ' AND cust.id = '.(int)$this->customer_id;
}

$result = database_query($sql, DATA_AND_ROWS, ALL_ROWS, FETCH_ASSOC);

if($result[1] > 0){
$output .= '<form action="" method="post"><table width="100%" dir="'.Application::Get('lang_dir').'" border="0" cellspacing="0" cellpadding="3" style="border:1px solid #d1d2d3">';
$output .= '<tr style="background-color:#e1e2e3;font-weight:bold;font-size:13px;">
<th align="center" > # </th>
<th align="center" width="60px">Código </th>
<th align="center" width="40px">Imagem</th>
<th align="left" width="390px">'._PRODUCT.'</th>
<th align="center" width="180px"> '._UNIT_PRICE.' </th>
<th align="center" width="180px"> Desconto </th>
<th align="center" width="90px"> Qtde </th>
<th align="right" width="90px"> '._TOTAL.' </th>
</tr>';
for($i=0; $i < $result[1]; $i++){
$output .= '<tr>';
$output .= ' <td align="center" width="40px">'.($i+1).'.</td>';
$output .= ' <td align="center">'.$result[0][$i]['sku'].' </td>';
$output .= ' <td align="center"><img src="images/products/'.$result[0][$i]['icon_thumb'].'" width="30px" height="30px"/> </td>';
$output .= ' <td align="left">'.$result[0][$i]['product_name'].' </td>';
$output .= ' <td align="center">'.Currencies::PriceFormat($result[0][$i]['unit_price'], '', '', $this->currency_format).'</td>';
$output .= ' <td align="center"><input type="numeric" name="desconto" value='.$result[0][$i]['desconto].'></td>';
$output .= ' <td align="center">'.$result[0][$i]['amount'].'</td>';
$output .= ' <td align="right">'.Currencies::PriceFormat($result[0][$i]['units_total_price'], '', '', $this->currency_format).'</td>';
$output .= '<td align="right"><input class="form_button" type="submit" name="submit" value="'._BUTTON_UPDATE.'"></td>';
$output .= '</tr>';
}

$output .= '</table></form>';
}


return $output;

if(isset($_POST['submit'])) {
$des = $_POST['desconto'];
$id = $result[0][$i]['id'];
$q = database_query("UPDATE apsc_orders_orcar_description SET desconto = {$des} WHERE id={$id}");
}