data transfer

[sanu]

i am trying to transfer data from one table to another for search index i wrote this code but only few data transfered rest not i can't find out what is the problem please help me code below:

include("./config.inc.php");
$db=connect_db();
$db_name=db_name();
$select_db=mysql_select_db($db_name,$db);
if(!$select_db)
{
print("$db_name not found");
exit();
}

?>

[bastien]

you could try changing the sql to this for the insert

$query_poem_search="INSERT INTO search(url,name,description,title,type)values('.$li
nkPoem.','.$Writer_name_poem.','.$Poem_content.','.$Poem
_title.','Poem.')";

add the concatenation operator to the query to specifically separate out the variables

hth

[sanu]

my problem is some of the data transfered some not i tried with concat still do not working 😕