On 4/14/06, P. Guethlein <[EMAIL PROTECTED]> wrote:
> This seems like it should work, but the option statement is just
> filling in one line of data....hmmmmm...  the names have multiple
> territories (ID's), so I want to have one name associated with one
> territory ID ( other stuff happens elseware...).
>
> //building list of names and their territory matching ID's
>                            while($getidsd = mysql_fetch_array($getidsr)){
>                            if ($getidsd['employeeid'] != '990'&&
> $getidsd['employeeid'] != '991') {
>                         $salespersonsstor= Array("name"=>$getidsd['fname'].'
> '.$getidsd['lname'],"idIS"=>$getidsd['employeeid']);
>                            }
>                                         }

You're always overwriting the array here. PHP arrays can't have
duplicate keys, so it's doing:

name -> $getidsd['fname'];

next time it gets a row, it's overwriting it.

If you do something like this:

 $salespersonsstor[] = Array("name"=>$getidsd['fname'].'
'.$getidsd['lname'],"idIS"=>$getidsd['employeeid']);

it will add to the array (notice the square brackets).

Do a print_r or var_dump after your loop so you understand how the
array is put together and how you can then use it.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Reply via email to