Query Loop within Query Loop .... Need Optimization help

[Dean C]

Ok do you know how serialization works? Basically when managing your categories from the admincp you run a query like this:

[sql]
SELECT categoryid, title FROM category_table WHERE parentid = $categorid
[/sql]

Then look through it like so:

PHP Code:

while($subcats = $DB_site->fetch_array($query))
{
       $array .= $subscats;
}

$subcats2 = serialize($array);

$DB_site->query("UPDATE category_table SET subnodes='" . addslashes($subcats2) . "' WHERE categoryid=$categorid");