[RESOLVED] Help with SELECT and then INSERT an array

[grumpy]

Hello-
I have some code, below, which is supposed to SELECT an array of id's from one table then INSERT them into another table, one per row. In my code, the SELECT functions okay, but I can't get the INSERT to work. I get an error on the second foreach: "Warning: Invalid argument supplied for foreach()" and nothing is inserted.

When I echo the "$rowID", it returns a correct string. (The 'MainCategoryID' and 'busid' come from sessions variables)

Any help would be appreciated. Thanks.

$subcat=$_POST['subcat'];
foreach( $subcat as $k ){$sql= "Select * from Category where MasterCategoryID='$maincategoryID' and ID='$k'"; 
    $result= mysql_query($sql);
	while ($row = mysql_fetch_array($result)) { 
	$rowID=$row["ID"];
	echo $rowID;
	}
	}
	foreach($rowID as $m )
	{
	$sql= "INSERT INTO BusinessGuide SET ID='$busid', UserInfoID='$busid', CategoryID='$m'"; 
	}

[halojoy]

you probably should make this little change

<?php

$subcat=$_POST['subcat'];
foreach( $subcat as $k ){
    //call the DB and check if is such ID
	$sql= "Select * from Category where MasterCategoryID='$maincategoryID' and ID='$k'";
    $result= mysql_query($sql);
    while ($row = mysql_fetch_array($result)) {
        //collect each ID into an array
	    $rowids[] = $row["ID"];
	    echo $row['ID'].'<br />';
    }
}
//insert each found ID from the array
foreach($rowids as $m ){
    $sql= "INSERT INTO BusinessGuide SET ID='$busid', UserInfoID='$busid', CategoryID='$m'";
} 

[grumpy]

Now I'm no longer getting the error, but now it is only inserting one of the results of the SELECT query. If the result of the SELECT is three elements, it should be inserting three rows into the BusinessGuide table, each with a different CategoryID. What am I still missing?

[grumpy]

For anyone with a similar problem, I figured out how to get this working:

$subcat=$_POST['subcat']; 
foreach( $subcat as $k ){ 
    //call the DB and check if is such ID 
    $sql= "Select * from Category where MasterCategoryID='$maincategoryID' and ID='$k'"; 
    $result= mysql_query($sql); 
    while ($row = mysql_fetch_array($result)) { 
        //collect each ID into an array 
        $rowids[] = $row["ID"]; 
       // echo $row['ID'].'<br />'; 
    } 
} 


for($i=0;$i<count($rowids);$i++)
{ 
$val=$rowids[$i];
$str="INSERT INTO BusinessGuide SET ID='$busid', UserInfoID='$busid', CategoryID='$val'";
$res=mysql_query($str);