insert query results into array

[mikawhat]

I want to insert my query results into an array for sorting. The code i'm using will display the results but not in alphabetical order, so i'd like to insert them into an array and use sort().

$q2 = @mysql_query("SELECT LAN_details.name, LAN_details.telephone FROM LAN_details, LAN_detailcategory, LAN_category 
WHERE LAN_details.id=LAN_detailcategory.detailid AND LAN_category.id=LAN_detailcategory.categoryid AND LAN_category.name='bars'
ORDER BY LAN_details.id 	LIMIT 5, 25");

while ($row = mysql_fetch_array($q2)) {
  $name = $row[1];
  $telephone = $row[2];
  echo "$name - $telephone<br>";
}

[j_70]

It is generally more efficient and a better solution to do your sorting in the database. I see you have an orderby clause, can't you order by the column you want here?

[mikawhat]

i don't think so. i need to get rows 5 to 25 ordered by id, and then alphabetically.

[NogDog]

The basic way to get a query result set into a 2-dim array, where the dim-1 index is the row number (zero-based) and the dim-2 index is the result column name:

$data = array();
while($row = mysql_fetch_assoc($this->result))
{
   $data[] = $row;
}

[inotgood]

try this

sort($name); - or - sort($telephone);

that will wort the variable