Script Insert

[martin_9_91]

Hacelo así:

Código 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, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, ihome from nuke_stories limit 6"); 
while($fila=mysql_fetch_array($consulta)){ 
$sid = $fila['sid']; 
$title = $fila['title']; 
$time = $fila['time']; 
$hometext = $fila['hometext']; 
$body = $fila['bodytext']; 
 
 
$title = $fila['title']; 
echo"$body"; 
echo "<p>ID $sid fecha: $time noticia: $title</p>"; 
 
$sqlinsert="INSERT INTO wp_posts VALUES ('$sid', '1', '$time', '$time', '$hometext', '$title','', 'publish', 'open', 'open', '','','','', '$time', '$time','', '0 ','', '0', 'post','', '0 '); ";  
mysql_query ($sqlinsert) 
OR die("Fatal error" ); 
 
}