[SOLVED] math ordering numbers

[Jiraiya]

i was wondering how do i display a list of numbers from a database table from highest to lowest?

[genericnumber1]

the easiest way would be when you query just ordering by the number's column descending.

[Jiraiya]

what would that code look like if you dont mind please

[genericnumber1]

assuming you want to retrieve all columns from a table named "table" with a column containing the numbers you wish to sort by named "numbers"

 

SELECT * FROM table ORDER BY numbers DESC

[Jiraiya]

what if i only wanted to display certain parts of the table along with the variable that i need displayed from highest to lowest?

[genericnumber1]

just add the where clause to the query.........

 

SELECT * FROM table WHERE something='something' ORDER BY numbers DESC

 

you might want to look up some sql tutorials to get the basics down.

[Jiraiya]

it didnt work this is the script i have

 

 

 

mysql_select_db("members", $con);

 

 

 

$result = mysql_query("SELECT * FROM users WHERE skill='skill' ORDER BY skill DESC");

 

echo "<table border='1'>

<tr>

<th>Name</th>

<th>Rank</th>

<th>Skill</th>

<th>Kekkei Genkai</th>

 

</tr>";

 

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['username'] . "</td>";

  echo "<td>" . $row['rank'] . "</td>";

  echo "<td>" . $row['skill'] . "</td>";

  echo "<td>" . $row['bloodline'] . "</td>";

  echo "</tr>";

  }

echo "</table>";

 

mysql_close($con);

?>

 

 

 

</body>

</html>

 

[genericnumber1]

did you mean ORDER BY rank DESC? you pulled where skill='skill'... there's no reason to sort by a value when only one unique value exists.

[Jiraiya]

no i need it ordered by skill

[genericnumber1]

... you're using WHERE skill='skill' that means you're only retrieving values from the database where the value in the skill column is skill....

 

you then sort by skill....

 

all results have "skill" for the skill value because you specifically said those were the columns you wanted....

 

...

 

if you sort by skill where all values are skill there's no sorting to be done...

 

...

 

I really can't help you if you can't understand the problem with the logic here.

[Jiraiya]

i understand the problem how do i fix it wanna display all the data that is listed below it but i need it to be ordered based on the skill variable

[genericnumber1]

Why are you selecting all values where the column skill has "skill" for the value?

[Jiraiya]

im kinda new at this and i know my mistake im just not sure how to fix it

[Jiraiya]

should i replace 'skill' in skill='skill with the name of the table? that the data is in

[genericnumber1]

How about this:

tell me exactly what you want to retrieve from the table and I'll tell you the query to use. Then we can discuss why I suggested the query I did.

[Jiraiya]

i want to display this but i want to have it in order by highest to lowest based on the skill variable

 

<th>Name</th>

<th>Rank</th>

<th>Skill</th>

<th>Kekkei Genkai</th>

 

</tr>";

 

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['username'] . "</td>";

  echo "<td>" . $row['rank'] . "</td>";

  echo "<td>" . $row['skill'] . "</td>";

  echo "<td>" . $row['bloodline'] . "</td>";

  echo "</tr>";

[genericnumber1]

Okay... let's try this one more time...

 

give me 5 values from the table and tell me which values you wish to retrieve and in which order and I will tell you the query to use.

[Jiraiya]

theres just 4 variables i want to display they are username, rank ,skill and bloodline. i want it to be in order from highest skill to lowest skill

[genericnumber1]

then just try

 

SELECT * FROM users ORDER BY skill DESC

[Jiraiya]

i tried that the page came up blank

 

 

mysql_select_db("members", $con);

 

 

SELECT * FROM users ORDER BY skill DESC

 

$result = mysql_query("SELECT * FROM users ORDER BY skill DESC");

 

echo "<table border='1'>

<tr>

<th>Name</th>

<th>Rank</th>

<th>Skill</th>

<th>Kekkei Genkai</th>

 

</tr>";

 

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['username'] . "</td>";

  echo "<td>" . $row['rank'] . "</td>";

  echo "<td>" . $row['skill'] . "</td>";

  echo "<td>" . $row['bloodline'] . "</td>";

  echo "</tr>";

  }

echo "</table>";

 

mysql_close($con);

?>

 

 

 

</body>

</html>

 

 

 

 

[genericnumber1]

add

error_reporting(E_ALL);

to the top line of your script

[Jiraiya]

it still came up blank

[genericnumber1]

When you say "blank" what do you mean? completely white or just no results?

[dropfaith]

<?php
mysql_select_db("members", $con);
$query = "SELECT * FROM users ORDER BY skill DESC";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Rank</th>
<th>Skill</th>
<th>Kekkei Genkai</th>
</tr>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['username'] . "</td>";
  echo "<td>" . $row['rank'] . "</td>";
  echo "<td>" . $row['skill'] . "</td>";
  echo "<td>" . $row['bloodline'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>



</body>
</html>

[Jiraiya]

its coming up white