Dynamic creating menu-items from external database - Joomla! Forum - community, help and support

hi,

my tabeltennisclub has new joomla (2.5) website, , used develope in joomla or known in extensions find ones fullfill needs.

url: www.ttvheerlen.nl
situation: 1 joomla database + 1 seperate database results of seasons/leagues.
where: main menu, main item "wedstrijden" (dutch, site has no translations), , items below (like below "2012 najaarscompetitie" '2012 autumnseason'.

the items in 'the season', dames (ladies) x, heren (mens) x, jongens (boys) x, need them create manually every half year , developer likes: no handmade things do, automatically.

so how that? data menu link, stored in seperate database. use main menu, no other menu (which maybe data external database, 1 if there one?).

my question(s): possible fill main menu (or menu extension) items fill (url, title/name) external database? there extensions that, or possible develope myself (i have experience, not in php, able myself) need explainations, kind of hand-out/manual how it.

can me? give advice?

thanks

carsten

hi carsten,

i'm not sure i'm understanding need , understand, i'm not sure have complete solution, might give pieces of puzzle.

you create menu entries making entries directly in menu table of joomla database. take bit of code make dynamic if can write bit of php, can make work.

to data need menus, you'll need pull data second database joomla database. part i'm not sure how do.

after that, i'd at: http://docs.joomla.org/developing_a_mod ... t_-_part_1 learn developing component package code nicely.

a bit of code think follows. it's performing sql commands within joomla code. you'd want change $query whatever sql command need create appropriate menu entries.

code: select all

   $db = jfactory::getdbo();
   $query = "select title #__content id<='25'";
   $db->setquery($query);


this link gives functional helloworld extension: http://joomlacode.org/gf/download/frsre ... lo1_01.zip

that's can think of help.

good luck.