I'm having a PHP/MySQL problem. Help would be appreciated! :)

[Ocean]

Originally Posted by Colin F

You would have to make a small script, something like this:

<snip>

You might have to change the explode part to fit whatever the data looks like now.

So, if I have this script saved as a PHP file:

PHP Code:

 
<?php
 
$threads = $DB_site->query("SELECT threadid,whoviewed FROM " . TABLE_PREFIX . "thread WHERE whoviewed != ''"); 
while ($thread = $DB_site->fetch_array($threads)) 
{ 
$vieweduserids = explode(" ", $thread['whoviewed']); 
$changeduserids = implode(",", $vieweduserids); 
$DB_site->query("UPDATE thread SET whoviewed = '$changeduserids' WHERE threadid = $thread[threadid]"); 
} 
 
?>

... what is the recommended way of running this script?

Is it just a matter of calling it from a URL? (i.e. www.mydomain.com/forums/customscript.php)

If so, are there any arguments that need to be passed? I'd be concerned as to whether it processed the correct board or not. (as I also might have www.mydomain.com/forum2)


Thanks!