On Sat, 19 Jun 2004 13:25:54 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> 
> How do I iterate over fields when I perform the below script:
...
> If I write the below code, I only get the first field name of each
> row...which makes sense
> In this case, I get 'artist_name'
> 
> while ($row = mysql_fetch_assoc($result))
>        {
>        $fieldName= key($row);
>        echo 'fieldName is: '.$fieldName."\n";
>        }

<?php
while ($row = mysql_fetch_assoc($result)) {
   foreach ($row as $fieldName => $fieldValue) {
      echo 'fieldName is: '.$fieldName."\n";
      echo 'fieldValue is: '.$fieldValue."\n";
   }
}
?>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to