min values / group by

[TTT]

is there some reason that MIN(id) AS id doesn't work (odbc/mssql)

..and ORDER BY id ASC GROUP BY parent doesn't either work, even if: SELECT id,parent...

[dannys]

I'm pretty sure that 2nd query should be :

...GROUP BY parent ORDER BY id ASC

[TTT]

here is one problem
select MIN(id) AS id,parent from department where parent = $page_parent AND id NOT IN ($List)

so, this doesn't give any result, but if:
select id,parent from .... // then query works but get's max value order by id asc doesn't work because it gives querys max(id)
and DESC gives total max id

-1 //first value
2 //this is skipped
3 //this is fetched if ASC
4
5
11 // if DESC

[[deleted]]

select MIN(id) AS id,parent

This is not possible, the MIN(id) will report only one result no matter how many matches there are in the WHERE clause, while 'parent' will return one result for every match in the WHERE clause.

SQL is pretty clever, but it cannot give one result and at the same time many results.

[TTT]

eh...you are right vincente... have to use group by parent.
any idea how to make recurse array with index

1.0 -->index=1
3.1
4.1

6.4
7.4
2.0 ---> index = 6
5.2

[[deleted]]

What exactly do you mean?

[TTT]

i ment if id and parent {id,parent} has relation, how to make array that starts from 1,0 --> x,1 --> smallest id from next level. after peek founded loop turns back and tries to find crossing below, until loop get's into x,0 -level and loop starts again from ex. 6,0.
it's important that array be made up like this, array[$indexNumber][{1,2,3,4[id,parent,name,depth]}], because then array can be looped ex. in navigation (depth=4) --> 4 times
select id from table where parent = $current_id.

my depth count goes right but $query[$depthCount] doesn't...

[dannys]

How about posting some example data and the result you want?