norus Posted August 17, 2015 Share Posted August 17, 2015 I need some help with following WP query and insert. Query $arrAddress generates 1 record with address data from a address table. That works fine. Second query check if $user_id is present in testament table. If not present it must insert the data from address table into testament table. I only do not know how to get the address data into table testament. Each address must get a record in testament table. Fields in wp_mm_testament are: userid, field_id, field_value Means after insert, i get: 90, '3' => $arrAddress['first_name'] 90, '4' => $arrAddress['last_name'] 90, '5' => $arrAddress['gender'] 90, '6' => $arrAddress['street_address'] 90, '7' => $arrAddress['zipcode'] 90, '8' => $arrAddress['city'] 90, '9' => $arrAddress['country'] Hope someone of you with more experience then me can help me. Thanks in advance. print_r($arrAddress) output: stdClass Object ( [id] => 3 [user_id] => 100 [gender] => m [first_name] => Meindert Hendrik [last_name] => Heide Groot [street_address] => Huizenbrink 12 [zipcode] => 8929GH [city] => Eibergen [country] => Nederland ) $arrAddress = $GLOBALS['wpdb']->get_row('SELECT * FROM wp_mm_users_address WHERE user_id = "'.$user_id.'" ');$arrTestament = $GLOBALS['wpdb']->get_row('SELECT userid FROM wp_mm_testament WHERE userid = "'.$user_id.'" ');if(count($arrTestament) == 0) { // fields in wp_mm_testament are: userid, field_id, field_valueif(count($arrAddress) > 0) { // wp_mm_users_address has address of user $user_id['wpdb']->insert('wp_mm_testament', array( 'userid' => $user_id, '3' => $arrAddress['first_name'], 'userid' => $user_id, '4' => $arrAddress['last_name'], 'userid' => $user_id, '5' => $arrAddress['gender'],'userid' => $user_id, '6' => $arrAddress['street_address'],'userid' => $user_id, '7' => $arrAddress['zipcode'],'userid' => $user_id, '8' => $arrAddress['city'],'userid' => $user_id, '9' => $arrAddress['country']));}} Link to comment https://forums.phpfreaks.com/topic/297825-wordpress-table-insert-with-multiple-rows-out-of-1-record/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.