Re: arrays and nested arrays and loops and databases...

If I understand correctly, you want to have an array containing an array with people's email address and name from your db like this: $to[0]['address'] = user@domain.com $to[0]['name'] = Bob Smith $to[1]['address'] = otheruser@otherdomain.com $to[1]['name'] = John Jones (the above is obviously not valid PHP...) I would do something like this: $to = array(); $query = "select email, fullname from tablename where updateannounce = 1"; $result = mysql_query($query); while ($output = mysql_fetch_array($result)) { $to[] = array('address' => $output['address'], 'name' => $output['name']); } assuming, of course, that your database column names are 'address' and 'name'. This should work, but I may have borked something up on the name based arrays. -Dash "The pyramid is opening!" "Which one?" "The one with the ever-widening hole in it!" -- Firesign Theater, "How Can You Be In Two Places At Once When You're Not Anywhere At All" On Sat, 18 Jan 2003, H Marc Bower wrote: > Well... I can usually puzzle myself through these things, but I figured > it's time to ask the list. :) It may be a simple thing that I'm missing, > but here's what I have. > > The structure that I'm trying to modify is as follows: > > $to = array( > array( > 'address'=>'user@domain.com', > 'name'=>'Bob Smith' > ), > array( > 'address'=>'otheruser@otherdomain.com', > 'name'=>'John Jones' > ) > ); > > That said, I have a database of names and email addresses which I want to > insert into this structure, but in a loop since I don't want to have an > array() section for each one, not knowing how many are going to be in the > list at the time this script is run. I want to loop the 'sub' array() > statements so that I can build up the main array(). I use mysql as follows: > > $query = "select email, fullname from tablename where updateannounce = 1"; > $result = mysql_query($query); > while ($output = mysql_fetch_array($result)) > { > //This is where I want the loop of arrays to appear, so I can > dynamically insert the email and fullname fields into the obvious spots > } > > > I need to figure out how to do this, essentially: > > $to = array(<loop to fill other array() statements>); > > I don't know how to get that loop to work inside the overall array() > statement, though... any assistance would be greatly appreciated. > > Thank you, > > Marc > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >