Hi dear
am having the more then 1000 records,
I want to insert the <--break-->,in that 1000 record ,
in that there is field called body, which contain article, too big content in that , now i want to insert the <--break-->, after every 1075 character has meet,
also Never broke the html tag...that is dont put the <--break-->
between <<--break-->table>..
for this i written the code
<?php mysql_connect("localhost","root","admin"); mysql_select_db("sample") or die("could not select the database"); $sql = "select * from node_revisions"; $rs = mysql_query($sql); if(mysql_num_rows($rs)>0) { while($obj=mysql_fetch_object($rs)) { $body_chunksplit = $obj->body; $nid=$obj->nid; $body_chunksplit=str_replace("'", "'", $body_chunksplit); $lrn = strlen($body_chunksplit); $length=$lrn*2;
if(strlen($body_chunksplit) >= 4500) { $body_content=substr(chunk_split($body_chunksplit, 4500, "<--pagebreak-->"), 0, $length); //drupal_set_message(wordcount($body_content)); } else { $body_content=$body_chunksplit; } mysql_query("UPDATE node_revisions SET body='$body_content' where nid='$nid'") or die("could not"); }
}
?>
This is will not solved my total problem,
Can any find the bug and solve it...