Odtnhj

I am working on a project where I would like to programmatically create wordpress posts using an SQL query from an external database. I have been able to populate HighCharts graphs and display data in a tabular format querying the SQL databases with PHP. However, I can not figure out how to use wp_insert_post in the same way. I am also unsure where I should put this code. Any help is much appreciated! Here is my PHP.

<?php
/**
 * Plugin Name: Post Creator

 * Description: Matt's Post Creator
 * Version: 0.2
 * Author: Matt 
 * Author URI:
 * License: GPLv2
 */

/**
 * Enable PHP in Widgets
 */

$conzz = mysql_connect("localhost","database","databasepassword");





if (!$conzz) 


 die('Could not connect: ' . mysql_error());








mysql_select_db("chiensi_testing", $conzz);




$resultzz = mysql_query("SELECT T1.ID, REBATE_CODE, LONG_DESC, INCENT_TECH_ID, UPGRADE_TECH FROM T_L_INCENTIVES T1 INNER JOIN T_L_INCENT_TECH T2 ON T1.L_INCENT_TECH = T2.ID INNER JOIN T_LIGHTING_TYPE T3 ON T2.E_LIGHTING_TYPE_ID = T3.ID");



while($row = mysql_fetch_array($resultzz)) 


 global $user_ID;
$new_post = array(
'post_title' => $row['REBATE_CODE'] ,
'post_content' => $row['LONG_DESC'] ,
'post_status' => 'publish',
'post_date' => date('Y-m-d H:i:s'),
'post_author' => $user_ID,
'post_type' => 'post',
'post_category' => array(10)
);
$posts_array=$new_post;



mysqli_close($conzz);

foreach ( $posts_array as $post ) 

$post_id = wp_insert_post($post);
;


?>

EDITED AFTER COMMENTS BELOW:

Try killing your connection to the first database before attempting to call wp_insert_post

$conzz = mysql_connect("localhost","database","databasepassword");
 if (!$conzz) 
die('Could not connect: ' . mysql_error());



mysql_select_db("database_name", $conzz);

 $resultzz = mysql_query("SELECT T1.ID, REBATE_CODE, LONG_DESC, INCENT_TECH_ID, UPGRADE_TECH FROM T_L_INCENTIVES T1 INNER JOIN T_L_INCENT_TECH T2 ON T1.L_INCENT_TECH = T2.ID INNER JOIN T_LIGHTING_TYPE T3 ON T2.E_LIGHTING_TYPE_ID = T3.ID");

$posts_array = array();

while($row = mysql_fetch_array($resultzz)) 


 global $user_ID;
$new_post = array(
'post_title' => $row['REBATE_CODE'] ,
'post_content' => $row['LONG_DESC'] ,
'post_status' => 'publish',
'post_date' => date('Y-m-d H:i:s'),
'post_author' => $user_ID,
'post_type' => 'post',
'post_category' => array(10)
);
$posts_array=$new_post;



mysqli_close($conzz);

foreach ( $posts_array as $post ) 

$post_id = wp_insert_post($post);
;



?>