Re: building a key value pair dynamically

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



sorry i should of explained a little more in depth :-).

i am using smarty templating engine,

and it needs me to pass in an associative array.

only an id column and a the name column.

i know if i use a more specific query, but if i have the result set already could i build the array so it suits the template function?

this is the function details:

http://www.smarty.net/docsv2/en/language.function.html.options.tpl

and this is the array im currently fetching.

Array ( [0] => Array ( [id] => 2 [0] => 2 [name] => category 1 [1] => category 1 [main_nav] => true [2] => true ) [1] => Array ( [id] => 3 [0] => 3 [name] => category 2 [1] => category 2 [main_nav] => true [2] => true ) [2] => Array ( [id] => 4 [0] => 4 [name] => category 3 [1] => category 3 [main_nav] => true [2] => true ) [3] => Array ( [id] => 5 [0] => 5 [name] => category 4 [1] => category 4 [main_nav] => true [2] => true ) [4] => Array ( [id] => 6 [0] => 6 [name] => category 5 [1] => category 5 [main_nav] => true [2] => true ) [5] => Array ( [id] => 7 [0] => 7 [name] => category 6 [1] => category 6 [main_nav] => false [2] => false ) [6] => Array ( [id] => 8 [0] => 8 [name] => category 7 [1] => category 7 [main_nav] => false [2] => false ) [7] => Array ( [id] => 9 [0] => 9 [name] => category 8 [1] => category 8 [main_nav] => false [2] => false ) [8] => Array ( [id] => 10 [0] => 10 [name] => category 9 [1] => category 9 [main_nav] => false [2] => false ) [9] => Array ( [id] => 11 [0] => 11 [name] => category 10 [1] => category 10 [main_nav] => false [2] => false ) ) Array ( [0] => 2=>category 1 [1] => 3=>category 2 [2] => 4=>category 3 [3] => 5=>category 4 [4] => 6=>category 5 [5] => 7=>category 6 [6] => 8=>category 7 [7] => 9=>category 8 [8] => 10=>category 9 [9] => 11=>category 10 

hope this makes sense?

kind regards


Adam

On 1 Jun 2011, at 16:33, jean-baptiste verrey wrote:

> with mysql use mysql_fetch_assoc, is that what you are asking for ?
> 
> On 1 June 2011 16:31, Adam Preece <ad84@xxxxxxxxxxxxxxxx> wrote:
> hi all,
> 
> is it possible to dynamically build a key value pair array in php from a database result?
> 
> if so how?
> 
> kind regards
> 
> Adam
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux