[RESOLVED] Stupid Array Question

[tony_l]

This maybe the stupidest thing ever, but I am having trouble with an array....

Here is the code -

//construct array of subscriptions already done.
	$subQuery = "SELECT sub_id FROM $GCC_SUBS WHERE email = '{$mlo->emailAddress}'";
	$subResults = mysql_query($subQuery);

$arr = mysql_fetch_array($subResults,MYSQL_ASSOC);

The resulting query, when put through phpMyAdmin, gives the the correect result, which is 1,2,3.

But when I do this -

PRINT_R($arr);

I get this -

Array ( [sub_id] => 3 ) 

Why would the query get 3 id's, but the Array fetch from the results give only 1 item?

I am at a loss

[samudasu]

From the php manual:
array mysql_fetch_array ( resource result [, int result_type] )
Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.

mysql_fetch_array returns an array for the "current" fetched row only and not all rows. Since it moves the interal data pointer ahead, the current row is the last row and that's why you only see Array ( [sub_id] => 3 ). If you want to see all row values returned then do something like this:

while ($arr = mysql_fetch_array($subResults,MYSQL_ASSOC)) {
    print $arr['sub_id'];
}

[tony_l]

DOH!

I knew that really <grin>

Why did I not think of that? I guess I was working on it too long.

Thanks man.