On 4/14/06, P. Guethlein <peterg@xxxxxxxxxxxxx> 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
