Re: [PHP] Multidimentional array problems

2006-04-04 Thread John Wells 
On 4/3/06, Mace Eliason [EMAIL PROTECTED] wrote:
 This is what I am doing and the output (for testing) seems correct
 while($row=mysql_fetch_array($result))
 {
   $banner= array($arrayIndex = $row);

   echo $banner[$arrayIndex][image]. br;
   echo $banner[$arrayIndex][url]. br;
   echo $banner[$arrayIndex][display_type]. br;
   $arrayIndex++;
 }


Tom is correct, you're overwriting $banner each time.  While the
following is a bit verbose (Tom's assignment step is all you need),
this might help to show what's happening:

[code]
$banner_array = array();
while ($row = mysql_fetch_array($result))
{
 $banner_array[] = array(
   url = $row[url],
   image = $row[image],
   display_type = $row[display_type]
   );

}
[/code]

 $value=0;
  while($value  $number_of_banners_db )
  {
 echo $banner[$value][url]. br;
 echo $banner[$value][image]. br;
 echo $banner[$value][display_type]. br;
  }

Here you're also not incrementing your loop counter.  Try this:

[code]
foreach($banner_array as $banner)
{
 echo $banner[url] . br;
 echo $banner[image] . br;
 echo $banner[display_type] . br;
}
[/code]

HTH,

John W

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

[PHP] Multidimentional array problems

2006-04-03 Thread Mace Eliason 
Hi, 

I am trying to read form a database and place everything in a 
multi-dimentional array


This is what I am doing and the output (for testing) seems correct
while($row=mysql_fetch_array($result))
{
 $banner= array($arrayIndex = $row);

 echo $banner[$arrayIndex][image]. br;
 echo $banner[$arrayIndex][url]. br;
 echo $banner[$arrayIndex][display_type]. br;
 $arrayIndex++;
}


When I try and use
$value=0;
while($value  $number_of_banners_db )
{
   echo $banner[$value][url]. br;
   echo $banner[$value][image]. br;
   echo $banner[$value][display_type]. br;
}

I only get the last set of values that where entered into the array.  I 
want to be able to pull all the values out


$banner[0]['url']
$banner[1]['url']
$banner[2]['url']  etc.

I don't use arrays much and I have been going thru my books but I still 
can't seem to get it to work.


Thanks

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

Re: [PHP] Multidimentional array problems

2006-04-03 Thread Philip Hallstrom 
I am trying to read form a database and place everything in a 
multi-dimentional array


This is what I am doing and the output (for testing) seems correct
while($row=mysql_fetch_array($result))
{
$banner= array($arrayIndex = $row);

echo $banner[$arrayIndex][image]. br;
echo $banner[$arrayIndex][url]. br;
echo $banner[$arrayIndex][display_type]. br;
$arrayIndex++;
}


What are you setting $arrayIndex to initially (before the while loop 
starts?)



When I try and use
$value=0;
while($value  $number_of_banners_db )
{
  echo $banner[$value][url]. br;
  echo $banner[$value][image]. br;
  echo $banner[$value][display_type]. br;
}

I only get the last set of values that where entered into the array.  I want 
to be able to pull all the values out


$banner[0]['url']
$banner[1]['url']
$banner[2]['url']  etc.

I don't use arrays much and I have been going thru my books but I still can't 
seem to get it to work.


Try a print_r($banner) and see what it looks like

-philip

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

Re: [PHP] Multidimentional array problems

2006-04-03 Thread Tom Rogers 
Hi,

Tuesday, April 4, 2006, 8:37:18 AM, you wrote:
ME Hi, 

ME I am trying to read form a database and place everything in a 
ME multi-dimentional array

ME This is what I am doing and the output (for testing) seems correct
ME while($row=mysql_fetch_array($result))
ME {
ME   $banner= array($arrayIndex = $row);

ME   echo $banner[$arrayIndex][image]. br;
ME   echo $banner[$arrayIndex][url]. br;
ME   echo $banner[$arrayIndex][display_type]. br;
ME   $arrayIndex++;
ME }


ME When I try and use
ME $value=0;
ME  while($value  $number_of_banners_db )
ME  {
ME echo $banner[$value][url]. br;
ME echo $banner[$value][image]. br;
ME echo $banner[$value][display_type]. br;
ME  }

ME I only get the last set of values that where entered into the array.  I 
ME want to be able to pull all the values out

ME $banner[0]['url']
ME $banner[1]['url']
ME $banner[2]['url']  etc.

ME I don't use arrays much and I have been going thru my books but I still 
ME can't seem to get it to work.

ME Thanks

You are creating a new $banner each time it loops.
It should be like this:

$banner = array();
$arrayIndex = 0;
while($row=mysql_fetch_array($result))
{
  $banner[$arrayIndex] = $row;

  echo $banner[$arrayIndex][image]. br;
  echo $banner[$arrayIndex][url]. br;
  echo $banner[$arrayIndex][display_type]. br;
  $arrayIndex++;
}

-- 
regards,
Tom

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