Salut, vreau sa sortez aceste date din mysql dupa data, cea mai recenta prima etc, am incercat mai multe functii dar nu am reusit.. poate are cineva o rezolvare. Data este salvata in acest fel 2017-05-30 23:29:39

$sirSQL = "SELECT users.userId AS userId, userName, games.gameId AS gameId, points, date_of_point, gameName
FROM (points INNER JOIN users ON points.userId=users.userId)
INNER JOIN games ON points.gameId=games.gameId
WHERE users.userId=" . $_SESSION["user"];
$tabel = mysql_query($sirSQL);
$nr = mysql_num_rows($tabel);
if ($nr == 0)
print "Nu aveti niciun punctaj salvat in baza de date! <br />";
else
{
print '<div class="table table-bordered">
<!-- Default panel contents -->
<div class="panel-heading"><center><strong>Istoric joc</strong></center></div>

<!-- Table -->
<table class="table table-bordered">';

print "<tr>";
print "<td>";
print "Joc";
print "</td>";

print "<td>";
print "Cuncte";
print "</td>";

print "<td>";
print "Data";
print "</td>";

for ($i=1; $i<=$nr; $i++)
{
$rand = mysql_fetch_array($tabel);

$userId = intval(trim($rand["userId"]));
$userName = trim($rand["userName"]);
$gameId = intval(trim($rand["gameId"]));
$gameName = ucfirst(trim($rand["gameName"]));
$points = intval(trim($rand["points"]));
$date_of_point = trim($rand["date_of_point"]);
print "<tr>";
print "<td> <b>";
print $gameName;
print "</td>";

print "<td>";
print $points;
print "</td>";

print "<td>";
print $date_of_point;
print "</td>";

print "</tr>";
}

print '</table>
</div>';
}

ai incercat cam tot ce stiam eu.. nush ce sa zic

Cineva? up..

incearca cu acest query

$sirSQL = "SELECT users.userId AS userId, userName, games.gameId AS gameId, points, date_of_point, gameName
FROM (points INNER JOIN users ON points.userId=users.userId)
INNER JOIN games ON points.gameId=games.gameId
WHERE users.userId=".$_SESSION['user']." order by data desc";

schimbi data cu numele coloanei unde este data
iar in cazul in care apar cele mai vechi primele schimbi desc de la sfarsit cu asc

Schimbi data la coloană

[ Postat de pe Android ]

Arhivat , subiect inactiv mai bine de 3 zile.