Mysql select query with order by ASC and DESC

Mysql  select query  with order by ASC and DESC

mysql use two type of order:
1 ascending ASC
2 decending DESC 

ASCENDING ORDER

<?php
$sql="select * from 'your table name ' order by id  ASC ";
mysql_query($con,$sql);
?>


DECENDING ORDER

<?php
$sql="select * from 'your table name ' order by id DESC  ";
mysql_query($con,$sql);
?>