<?php

$sql="";

$dbhost = "localhost";
$user = "root";
$password = "";
$db = "wp";


$conn = mysql_connect($dbhost,$user,$password);
echo "[conn=$conn]<br>";

    $sql="select sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, ihome from wp.stories";

        if($conn){
            $result = mysql_query($sql);
echo "[result=$result]<br>";
            $nb = mysql_num_rows($result);
echo "[nb=$nb]<br>";

            while(list($sid, $catid, $aid, $title, $time, $hometext, $bodytext, $comments, $counter, $topic, $informant, $notes, $ihome) = mysql_fetch_row($result)) {
echo "----------------------------------------------------------------------<br>";

$title = addslashes($title);
echo "<br>title=$title<br>";
$hometext = addslashes($hometext);
echo "<br>hometext=$hometext<br>";
$bodytext = addslashes($bodytext);

//echo "<br>hometext=$hometext<br>";
          $sqlinsert="INSERT INTO `wp`.`wpfr_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 <!--more--> $bodytext', '$title', '', 'publish', 'open', 'open', '', '', '', '', '$time', '$time', '', '0', '', '0', 'post', '', '0'
                        );
                        ";
//          echo "<br>sqlinsert=[$sqlinsert]<br>";
          $insert = mysql_query($sqlinsert);
          echo "<br>insert=[$insert]<br>";
            }

        if($result){
          }else{
            echo "<br>sql=$sql<br><br>";
            echo "error mysql_query<br>";
          }
        }
        else{
            echo "<br>conn=$conn<br>";
            echo "<br>sql=$sql<br>";
            echo "error connect db";
        }

?>