$conn->Execute("SELECT id,name,parent,ordering FROM #__menu WHERE parent=0 AND menutype='mainmenu' ORDER BY ordering ASC");

db Object
(
[lm_db_host] =>
[lm_db_user] =>
[lm_db_pwd] =>
[lm_db_name] =>
[rowset] => Array
(
[0] => Array
(
[id] => 11
[name] => Поиск
[parent] => 0
[ordering] => 1
)
[1] => Array
(
[id] => 12
[name] => Авторизация
[parent] => 0
[ordering] => 2
)
)
[ErrorMsg] => Array ( [0] => )
[columns] =>
[nncolumns] =>
[nid] =>
[aff_rows] => 0
[lm_db_size] => Array ( )
[cache] => 1
[qcache] => 1
[dbcoding] => 1
[debug] =>
[error] =>
[prefix] => ON36ZE_
[sp] => SqlParser Object
(
[quoteChars] => Array
(
[0] => '
[1] => "
)
[escapeChar] => \
[whitespaceChars] => Array
(
[0] =>
[1] =>
[2] =>
[3] =>
)
[specialElements] => Array
(
[0] => <>
[1] => !=
[2] => >=
[3] => <=
[4] => =
[5] => <
[6] => >
[7] => LIKE
[8] => (
[9] => )
[10] => ;
[11] => ,
[12] => .
)
[removeQuotes] =>
[removeEscapeChars] => 1
[currentPos] => -1
[currentChar] =>
[inQuotes] => Array ( )
[lastWasEscape] =>
[currentIsEscape] =>
[currentElement] =>
[elementFinished] =>
[originalStr] =>
[workingStr] =>
[specialElementsMaxLen] => 0
[peekCache] =>
[queryIsCached] =>
[queryObjectCache] =>
)
[ext] => .php
[connect] => 1
[db_name] => Z:/home/limbo/www/data/
)