Murphy wrote: > update rules > set text = replace(text,'old','new') > where number = 106
FWIW, you're forgetting version numbers means every amendment is kept, so (forgiving the php intrusion): $query = "INSERT into $tablename values ('$rnum','$rver','$rflags', '$rtitle', '$rhistory', '$rcategory', '$rkeywords','$rtext')"; and for constructing the current operational ruleset, just take the max $rver for each $rnum, then you can also track back to old $rvers through a hotlinked history. And text manipulation is your friend, if yr using php anyway. Why were we doing this again? -Goethe