Support

September 23, 2015 at 9:10 am

Hi all, we’re doing some CRM integration for a client and I am having trouble inserting the venue information. My query is below, my variables are populated correctly as they print out fine if I echo them above this code. However the code just inserts blanks in to the database (except for the Venue ID which inserts fine!).

			$wpdb->insert( 
				$wpdb->prefix.'esp_venue_meta', 
				array( 
					'VNU_ID' => $venue_id,
					'VNU_address' => $venueAddress1, 
					'VNU_address2' => $venueAddress2, $venueAddress3,
					'VNU_city' => $venueCounty,
					'CNT_ISO' => 'GB',
					'VNU_zip' => $venuePostcode,
					'VNU_phone' => $venuePhone,
				),  
				array('%s','%s','%s','%s','%s','%s','%s') 
			);

Any points in the right direction would be very appreciated!!!

Thanks!