Script Insert

[martin_9_91]

Hace esto,

Código PHP:

<?php
 
$tabla = "wordpress"; 
$servidor = "localhost"; 
$usuario = "root"; 
$clave = ""; 
set_time_limit(0); 
mysql_select_db($tabla,mysql_connect($servidor,$usuario,$clave)) or die("Error de conexión con la base de datos."); 
$consulta = mysql_query("Select sid, title, time, hometext, bodytext from nuke_stories"); 
while($fila=mysql_fetch_array($consulta)){ 
$sid = "'" . $fila['sid'] . "'"; 
$title = "'" . $fila['title'] . "'"; 
$time = "'" . $fila['time'] . "'"; 
$hometext = "'" . $fila['hometext'] . "'"; 
$body = "'" . $fila['bodytext'] . "'"; 
 
echo"$body"; 
echo "<p>ID $sid fecha: $time noticia: $title</p>"; 
 
$sqlinsert="INSERT INTO wp_posts 
(ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count)
VALUES ($sid, '1', $time, $time, $hometext, $title,'', 'publish', 'open', 'open', '','','','', $time, $time,'', '0','', '0', 'post','', '0')";  
 
die($sqlinsert);
 
mysql_query ($sqlinsert) 
OR die(mysql_error() ); 
}
?>
 

Ese te va a devolver el insert y eso pegalo en mysql.

Te va a dar un error.

Ahí te vas a dar cuenta como solucionarlo.