thanks...that is what I had used previously :)
Another php coder had given me a hint that I could just take each incoming row on the fly with $row['artist_name'] without reading everything into an array:
What I had previously was:
while ($row = mysql_fetch_assoc($result))
{
$playlist[] = $row; //read in entire array before doing anything
}# get row count $c= count($playlist);
for ($x = 0; $x < $c; $x++)
{
foreach($playlist[$x] as $key => $val)
{
switch ($key)
{
# if key name is 'artist_name', do something
case 'artist_name' :
break; # if key name is 'urlPath', do something
case 'urlPath' :
break;
}
}
}is there a way to grab the info on the fly without reading the $result into an array ?
many thanks as I am on my 3rd week with php....
On Jun 19, 2004, at 1:45 PM, Robin Vickery wrote:
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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
