Posted by Toby Inkster on 11/14/05 22:19

guitarromantic wrote:

> Because I'd have to manually go through each one and process it through
> the system..?

Please quote the post you're replying to so that people know what you're
talking about.

No need to do it manually! Say you have a function "fixsymbols()" that can
fix the symbols, simply create a script like this:

$r = mysql_query("SELECT articleid, content FROM articles;");
while ($a = mysql_fetch_array($r))
{
$id = $a[0];
$content = addslashes(fixsymbols($a[1]));
$q = "UPDATE articles SET content='$content' WHERE articleid='$id';";
mysql_query($q);
}

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

• Next in forum: Re: mail() injection, am i safe?
• Prev in forum: Re: Does PHP have an equivalent of JavaScript's prototype object?
• Thread view: Re: nonstandard symbols: function to replace?

[Reply to this message]