[Michael]

is there a way to get a keyed array from 2 columns in the database?

I have 2 columns in the database
* ID * | * groupname * |
1 first group name
2 second group name
3 third group name

and want an array like this
1->first group name
2->second group name
3->third group name

so that i can give it straight to the 'jmChoose' function without having to step through it in a foreach loop. is it possible?

this is the current code, and i think the key is something to go where the current 'ID' is, but not sure what.

Code

$_groups = dbQuery("select * from {$jamroom_db['groups']}", 'ID'); jmChoose('Group','group',$_groups, $_selected, 'no', false ,"Select the group you'd like.",'group report viewing.');

the docs http://www.jamroom.net/Function_dbQuery seam to indicate that $column can be used so i think i need something like

'ID=>groupname' but am unsure of the syntax.

which would then produce:
<option value="1">first group name</option>
<option value="2">second group name</option>
<option value="3">third group name</option>


thanks

--edit--
still interested to know if its possible, but i went through a very small foreach and got is sorted.

Code

foreach($_ret as $key => $_vl){         $_groups[$key] = $_vl[groupname];         }

_________________
Michael Ussher
Jamroom Network Team Member: http://www.jamroom.net
Priority Support: http://www.jamroom.net/Support_Center

[Brian]

Yes - you can do this. You just need to define the column to want to return as the 5th argument, and the second argument needs to be the key - i.e.

Code

$req = "SELECT band_id, band_name           FROM {$jamroom_db['band_info']}"; $_rt = dbQuery($req,'band_id',null,false,'band_name');

You'll get the array you want as $_rt.

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation

[Michael]

Champion!!

Thought you would have built in some feature to make life easier.

Awesome, thanks.


_________________
Michael Ussher
Jamroom Network Team Member: http://www.jamroom.net
Priority Support: http://www.jamroom.net/Support_Center