inserting in database doesnot work

[kopietje]

Hi,

I don't know PHP and I feel desperate:

I inserted a new field in table orders_products: products_id_hkkp

 

The 1st step now is to fill this field in checkout_process.php, what doesnot work: the field stays empty

I don't know why

The value is ok in products_extra_fields_value (this is a contribute)

 

coding:

   $products_id_hkkp = tep_db_query("select products_extra_fields_value from products_to_products_extra_fields where products_extra_fields_id = 4 AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");
$record = tep_db_fetch_array($products_id_hkkp);

$sql_data_array = array('orders_id' => $insert_id,
						'products_id' => tep_get_prid($order->products[$i]['id']),
						'products_model' => $order->products[$i]['model'],
						'products_name' => $order->products[$i]['name'],
						'products_price' => $order->products[$i]['price'],
						'final_price' => $order->products[$i]['final_price'],
						'products_tax' => $order->products[$i]['tax'],
						'products_quantity' => $order->products[$i]['qty'],
						'products_id_hkkp' => $record['products_id_hkkp']);
tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);
$order_products_id = tep_db_insert_id();