[SOLVED] Foreach and MySql

[zackcez]

Well here's my current code:

	$getFeatures = $db->query("SELECT * FROM features WHERE product='1'");
	$feature       = mysql_fetch_array($getFeatures);
	$features     = array($feature['text']);
	foreach ($features as $featuree) {
	    echo"<li>$featuree</li>";
	}

Any one have any suggestions :s?

[ignace]

$features = mysql_fetch_assoc($result);

 

should give you someting like:

 

array(

0 => array(

  'rowfield' => 'rowvalue'

)

);

 

another option is the Iterator class as found in the PHP Standard PHP Library (SPL):

http://www.php.net/~helly/php/ext/spl/

 

or:

http://be.php.net/spl