TalkPHP - View Single Post

Alan @ CIT · 03-06-2008, 09:40 PM

oops, my fault - I had a blond moment

I'm so used to Zend_Db's fetchAll() method that I forgot that mysql_fetch_array() only returns the first result and that you have to loop through it to get them all

Remove the mysql_fetch_array() line and replace it with this:

PHP Code:


			
while ($item = mysql_fetch_array($rock_result))

{

    $items[] = $item['cd_artist'];

}

Hopefully that should work this time

Alan

03-06-2008, 09:40 PM	#13 (permalink)
Alan @ CIT Member of the Month The Frequenter Join Date: Apr 2005 Location: South UK Posts: 483 Thanks: 51	oops, my fault - I had a blond moment I'm so used to Zend_Db's fetchAll() method that I forgot that mysql_fetch_array() only returns the first result and that you have to loop through it to get them all Remove the mysql_fetch_array() line and replace it with this: PHP Code: `while ($item = mysql_fetch_array($rock_result)) { $items[] = $item['cd_artist']; }` Hopefully that should work this time Alan