Reverse mysql_fetch_array ()

Question

function outputscores($mysqlquery,$reverse=false)
{
    while($row = mysql_fetch_array($mysqlquery))
    {
        echo '<img src="img/date.png" /> ' . date("j M Y",strtotime($row['timestamp'])) . '
        <img src="img/time.png" /> ' . date("H:i:s",strtotime($row['timestamp'])) . '
        <img src="img/star.png" /> '.$row['score'].$_GET["scoretype"].'<br />';
    }
}

I need to change the array if the $ reverse parameter is set to true, but PHP says the output is mysql_fetch_arraynot a valid array. Also there is no $ mysqlquery.

Is there any help?

Wow, today I asked so many questions ._.

EDIT

$result = mysql_query("SELECT * FROM $gid LIMIT 25") or throwerror(mysql_error());

outputscores($result);

EDIT2 Another possible call:

$result = mysql_query("SELECT * FROM ".$gid.",users WHERE users.lastcheck < ".$gid.".timestamp") or throwerror(mysql_error());

outputscores($result);

Answer 1

Edit: change your SQL query to this:

$mysqlquery="SELECT * FROM $gid";

Change your function as follows:

function outputscores($mysqlquery,$reverse=false)
{
    if ($reverse==true)
        $mysqlquery.=" ORDER BY id DESC LIMIT 25";
    else
        $mysqlQuery.=" LIMIT 25";
    $result=mysql_query($mysqlquery);
    while($row = mysql_fetch_array($result))
    {
       //Do output here
    }
}

, ORDER BY id DESC, "id" . ASC DESC, . , "id" , timestamp, score ..

: , LIMIT ORDER BY . - :

$reverse=false;//or true
$mysqlquery=addOrderBy("SELECT * FROM $gid",$reverse);
outputScores($mysqlquery);

Answer 2

, , , - :

function outputscores($mysqlres,$reverse=false)
{
   $results = array();
   while($row = mysql_fetch_array($mysqlres)){
    print('I found a result: <pre>'.print_r($row, false).'</pre>'); //debugging purposes
    $results[] = $row;
   }
   if($reverse) { $results = array_reverse($results); }
   foreach($results as $row)
   {
    echo '<img src="img/date.png" /> ' . date("j M Y",strtotime($row['timestamp'])) .    '
    <img src="img/time.png" /> ' . date("H:i:s",strtotime($row['timestamp'])) . '
    <img src="img/star.png" /> '.$row['score'].$_GET["scoretype"].'<br />';
  }
}

, , soulmerge, mysql-, . :

$query = "SELECT field FROM table";
$res = mysql_query($query);
output_scores($res, true);

, , phpMyAdmin - while, .

Answer 3

, $mysqlquery mysql, . , mysql_fetch_array() :

• ( var_dump($mysqlquery))
• (mysql_fetch_array() FALSE).

, mysql_fetch_array(), . mysql_query(), -.

array_reverse(). :

$rows = array();
while ($row = mysql_fetch_array($result)) {
    $rows[] = $row;
}
array_reverse($rows);