MySQL duomenų rikiavimas

Taigi... man reikia, jog vartotojas pats pasirinktų duomenų rikiavimą paspaudęs, pvz., ant kokio paveikslėlio.

Kodas:

 

<...>
$max_entries = 30;

$total = mysql_num_rows(mysql_query("SELECT * FROM users"));
$psl = $_GET['psl'];
if (!$psl)
{ 
$psl=1; 
}

$start=($max_entries * $psl)-$max_entries;

if ($total <= $max_entries) 
{ 
$num_page=1; 
}
else if (($total % $max_entries)==0) 
{ 
$num_page=$total/$max_entries; 
}
else 
{ 
$num_page=$total/$max_entries + 1; 
}


echo "<table width='400' style='border-style: solid;border-width: 1px;border-collapse: collapse;background-color: rgb(250, 240, 230);'>
<tr>
<th style='color: #1C1C1C;background-color: white;'>ID</th>
<th style='color: #1C1C1C;background-color: white;'>Nick'as</th>
<th style='color: #1C1C1C;background-color: white;'>Pinigai(LTL) <form method='POST'><input type='submit' id='cash' name='cash' value='R' /></form></th>
<th style='color: #1C1C1C;background-color: white;'>Licencijos</th>
<th style='color: #1C1C1C;background-color: white;'>Numeriai</th>
</tr>";

if(!isset($r))
{
$q = "SELECT * FROM users ORDER BY id LIMIT $start, $max_entries";
$qr = mysql_query($q);
}


$r = $_POST['cash'];
$q1 = "SELECT * FROM users ORDER BY $r LIMIT $start, $max_entries";
$qr1 = mysql_query($q);


while($mas=mysql_fetch_array($qr1))
 {
 echo "<tr>"; 
 echo "<td style='color:#0B610B;border-top:1px solid #A4A4A4;'>" . $mas['id'] . "</td>";
 echo "<td style='color:#0B610B;border-top:1px solid #A4A4A4;font:bold 18px Verdana, Arial, Helvetica, sans-serif;'>" . get_racer($mas['username']) . "</td>";
 echo "<td style='color:#0B610B;border-top:1px solid #A4A4A4;'>" . $mas['cash'] . "</td>";
 echo "<td style='color:#0B610B;border-top:1px solid #A4A4A4;'>" . $mas['licence'] . "</td>";
 if($mas['plate'] == "!")
 {
 echo "<td style='color:red;border-top:1px solid #A4A4A4;'>Neregistruoti</td>";
 }
 else
 {
 echo "<td style='color:#0B610B;border-top:1px solid #A4A4A4;'>" . get_racer($mas['plate']) . "</td>";
 }
 echo "</tr>";
 }
echo "</table>";


echo "<FORM method=\"GET\" NAME=\"myforma\">";
echo "Puslapis: <SELECT onchange=\"goToUrl(this,'zaidejai.php?')\" NAME=\"zaid\">";
for ($i=1; $i<=$num_page; $i++)
{
if ($i!=$psl)
{
echo "<OPTION VALUE=\"".$i."\">" . $i . "</OPTION>";
}
else
{
echo "<OPTION VALUE=\"".$i."\" SELECTED=\"SELECTED\">" . $i . "</OPTION>";
}
}
echo "</SELECT></FORM>";

?>

 

Bandžiau keletą variantų su formom, get, post, bet nesigauna.. :/

Tikiuosi pagelbėsit :D

Redagavo Birželio 18, 2010 v1per

Patarimas: naudok normalius kintamuosius nes sunku susigaudyt :D

ORDER BY stulpelis DESC

pagal nutylėjimą yra ASC.

Va reali kodo dalis, kuri man kliūna:

 

echo "<table width='400' style='border-style: solid;border-width: 1px;border-collapse: collapse;background-color: rgb(250, 240, 230);'>
<tr>
<th style='color: #1C1C1C;background-color: white;'>ID</th>
<th style='color: #1C1C1C;background-color: white;'>Nick'as</th>
<th style='color: #1C1C1C;background-color: white;'>Pinigai(LTL) <form method='POST'><input type='submit' id='cash' name='cash' value='R' /></form></th>
<th style='color: #1C1C1C;background-color: white;'>Licencijos</th>
<th style='color: #1C1C1C;background-color: white;'>Numeriai</th>
</tr>";

if(!isset($r))
{
$q = "SELECT * FROM users ORDER BY id LIMIT $start, $max_entries";
$qr = mysql_query($q);
}


$r = $_POST['cash'];
$q1 = "SELECT * FROM users ORDER BY $r LIMIT $start, $max_entries";
$qr1 = mysql_query($q);

Tai niekas nepagelbės? :/

Tai niekas nepagelbės? :/

 

Tingiu gilintis smarkiai i koda, bet matau viena klaida:

$r = $_POST['cash'];

$q1 = "SELECT * FROM users ORDER BY $r LIMIT $start, $max_entries";

$qr1 = mysql_query($q);

 

Kintamuju vardai netinkamai uzvadinti.