I have a problem inserting values on my table.
--------------------------------------------
| products_id | related_products_ids |
| -----------------------------------------
| | 1,2,3,4,6, |
| -----------------------------------------
| 2 | 1,2,3,6, |
| -----------------------------------------
| 3 | 1,2,4, |
-------------------------------------------
There is a blank products_id
value where all inserted values on each product ids are on its related_products_ids
value.
I use this code,
for ($i=0; $i<count($_POST['rp_product']);$i++) {
$check_val .= $_POST['rp_product'][$i];
$check_val .=",";
}
$insert_rp_ids1 = explode(',', $check_val);
foreach($insert_rp_ids1 as $rp_ids) {
$related_query = "SELECT related_products_ids, products_id
FROM ".TABLE_RELATED_PRODUCTS."
WHERE products_id = '" . $rp_ids ."'";
$result_rp = mysql_query($related_query);
$related_products_value = mysql_fetch_assoc($result_rp);
if(mysql_num_rows(mysql_query("SELECT products_id FROM ".TABLE_RELATED_PRODUCTS." WHERE products_id = '$rp_ids'"))){
$rp_values = $related_products_value['related_products_ids'].$products_id.',';
$rps_each1 = array('related_products_ids' => $rp_values);
$wpdb->update( TABLE_RELATED_PRODUCTS, $rps_each1, array( 'products_id' => $rp_ids ));
} else {
$rps_each2 = array('products_id' => $rp_ids,
'related_products_ids' => $products_id.',');
$wpdb->insert(TABLE_RELATED_PRODUCTS, $rps_each2);
}
}
Is there something wrong with my code? I can't find it. That row is not necessary and its no use.
Please help.