[SOLVED] foreach loop and array help

[tekrscom]

Hi everyone, I was hoping for a bit of help with this loop and array I got here...

 

    <?
    $prequery = "SELECT InterestID FROM MemberInterests WHERE MemberID = '$_SESSION[MemberID]'";
    $preresults = mysql_query($prequery);
    while ($prerow = mysql_fetch_assoc($preresults)) {
	$myInterestsArray[] = $prerow;
}
    $query = "SELECT InterestID, InterestName FROM InterestTypes";
$results = mysql_query($query);
$RowsPerColumn = (mysql_num_rows($results) / 2);
$PrintedCounter = 0;
while ($row = mysql_fetch_assoc($results)) {
	$PrintedCounter += 1;
	echo '
        <tr>
            <td>
                ' . $row['InterestName'] . '
            </td>
            <td>
                <input type="checkbox" name="' . $row['InterestID'] . '"';
			foreach ($myInterestsArray as $key => $myInterestsArrayValue) {
				if ($row['InterestID'] == $myInterestsArrayValue) {echo ' checked';} 
			}
			echo '>
            </td>
        </tr>
	';
	if ($PrintedCounter == $RowsPerColumn) {
		echo '
                </table>
            </td>
            <td>
                <table style="width: 200px;">
		';
	}
}
    ?>

 

When I check the array with this...

	
<?
echo '<pre>';
print_r ($myInterestsArray);
echo '</pre>';
?>

 

I get this...

Array
(
    [0] => Array
        (
            [interestID] => 1
        )

    [1] => Array
        (
            [interestID] => 2
        )

    [2] => Array
        (
            [interestID] => 3
        )
etc, etc,...

[wshell]

Looks like you are looping through an array of arrays... so the value result of your for each is going to also be an array.    Try this..

 

if ($row['InterestID'] == $myInterestsArrayValue['InterestID']) {echo ' checked';} 

[tekrscom]

Looks like you are looping through an array of arrays... so the value result of your for each is going to also be an array.    Try this..

 

if ($row['InterestID'] == $myInterestsArrayValue['InterestID']) {echo ' checked';} 

 

Yes, that worked quite nicely.. I knew I had an array in an array, I just didn't know how to access it... Thank  you very much!

[wshell]

Glad to help...  cheers.