Display multiple rows from query

mitz

Hi,I have this query: $emparray = array(); $empquery = 'select distinct(o.name) from ost_ticket t, ost_user u, ost_organization o where t.user_id =u.id and u.org_id=o.id'; $empexquery = db_query($empquery); $emparray = db_result($empexquery,0,"name");Since the query returns multiple rows the $emparrys doens't work. I haven't got much experirience in php so can you please help me get these rows into an array and print them from 1 to 20? (I only want 20 orgs, i'll sort them later in that query).Thanks!

mitz

I've figured it out. here's result code if someone needs it: $sqlqry = 'select distinct(o.name) as val, count(*) as nts from ost_ticket t, ost_user u, ost_organization o where t.user_id =u.id and u.org_id=o.id group by org_id order by count(*) desc limit 21'; $sqlresult = db_query($sqlqry); $arrnameorg= array(); $arrtksorg= array(); $ctr=1; if ($sqlresult->num_rows > 0) { // output data of each row while($row = $sqlresult->fetch_assoc()) { echo "<br>". $row. " - ". $row. "<br>"; $arrnameorg=$row; $arrtksorg=$row; $ctr++; } } else { echo "0 results"; }