[SOLVED] reversing an array

[damian0612]

How can I reverse the results of an array in php?

 

I have queried mysql:

 

$result = mysql_query("            
SELECT * 
FROM fixtures
WHERE result != ''
ORDER BY date DESC
LIMIT 6", $connection);

 

Now, I want to reverse the results? I can't do it in the query as it will return many rows if I didn't limit it and these 6 are the ones I need, therefore if I ordered by ASC it would get a different 6 which I dont want.

 

I have tried:

 

foreach (array_reverse($result) as $result2) { 
   print "$result2";

 

But I get errors. Can anyone help?

 

Thanks

Damian

[RussellReal]

array_reverse

 

<3

[damian0612]

array_reverse

 

As u can see from the code I posted above I have tried to apply this however have been unsucessful, thus this post  ???

[thebadbad]

$reversed_array = array_reverse($result);

 

And then use $reversed_array in your foreach loop.

[DarkWater]

That code that you posted in the original post should work.  Which "errors" do you get?

[Daniel0]

You need to actually get the results first. You only have the resource returned by mysql_query.

 

See: mysql_fetch_assoc

[RussellReal]

try that

<?php
$result = mysql_query("SELECT * FROM fixtures WHERE result != '' ORDER BY date DESC LIMIT 6", $connection);
$results = array();
for ($i = (mysql_num_rows($result) - 1); $i > 0; $i--) {
	mysql_data_seek($result,$i);
	$results[] = mysql_fetch_assoc($result);
}
?>

 

note: its untested.. as I just wrote it, but if it doesn't work just tweak it a bit, thats along the lines of what you need

[Daniel0]

mysql_fetch_*() moves the pointer one position forward automatically, so you would have to decrement by 2 on each iteration instead.

[RussellReal]

daniel, actually, I'm decreasing the $i variable in each loop of the for, whether it is 7 or 8 when I go to set it to 6, it will still get set to 6

[Daniel0]

Right, sorry yeah, that's my fault. I was thinking for a moment that $i was the cursor, which it of course isn't. You're right

[.josh]

Think I'd rather stick with a regular while loop and array_reverse afterwards.  Seems a lot more cleaner/clearer in intention if reading, imo.

[RussellReal]

Think I'd rather stick with a regular while loop and array_reverse afterwards.  Seems a lot more cleaner/clearer in intention if reading, imo.

I know, thats what I was originally going to formulate for him, however, using the while loop, then array reverse, will ofcourse do the same operations double, instead my way, you get the data, and put it in the right place, at the same time

[.josh]

yeah I'm not arguing that ^^ is probably more efficient on the processor...but I think this is one of those cases if I were coding it, I'd sacrifice that smidgen of efficiency for readability.

 

edit: I mean, we are talking about a 6 row query...

[damian0612]

Thanks for your help, got it solved:

 

//temporary results array 
$results = array(); 

//our query 
$sql = "SELECT * FROM fixtures WHERE result != '' ORDER BY date DESC LIMIT 6"; 
$query = mysql_query($sql); 
while($result = mysql_fetch_assoc($query)){ 
  //store the results in an array 
  $results[] = $result; 
} 

//reverse our array 
$fixtures = array_reverse($results); 

//print our array 
foreach($fixtures as $fixture){ 
  print_r($fixture); 
}