Select MySQL

[duncan_cowan]

Is it possible to order a mysql table and then display the top 10 rows?

[aspnetguy]

SELECT * FROM tableName LIMIT 10

[duncan_cowan]

i would like it to order a colum before it displays the top 10

[justsomeguy]

You can use the ORDER BY clause to do that:

SELECT * FROM tableName ORDER BY column LIMIT 10

[duncan_cowan]

i have added this code to a page

<?phprequire 'protected/db_connect.php';$query = "SELECT * FROM armies ORDER BY strength DESC LIMIT 10";$result = mysql_query($query)	or		die("error couldnt execute query");echo "<table border='0'>			<tr>				<td><center><font color='#FFFFFF'>Name</td>				<td><center><font color='#FFFFFF'>Strength</td>		</tr>";while ( $row = mysql_fetch_array($result))	{		echo "<tr>";		echo "<td><center><font color='#FFFFFF'>" . $row['army name'] . "</td>";		  echo "<td><center><font color='#FFFFFF'>" . $row['strength'] . "</td>";		  echo "</tr>";	  }echo "</table>";?>

but when i run it it displays the numbers in this order: 9 7 7 6 5 4 3 2 1211why?

[aspnetguy]

is the field "strength" defined as INT?

[reportingsjr]

It will have to be defined as a type that can be ordered, like text wont work.

[duncan_cowan]

thanks alot