How to update table records and displaying in sorting order.

<?php
mysql_connect("localhost", "root", "pass") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());

//update Query
$result = mysql_query("UPDATE emp SET fieldname='robin' WHERE fieldname='rock'")
or die(mysql_error()); 

$result = mysql_query("SELECT * FROM emp WHERE fieldname='robin'") or die(mysql_error()); 

$row = mysql_fetch_array( $result );
echo $row['fieldname']." - ".$row['age'];

//Delete Query

mysql_query("DELETE FROM emp WHERE fieldname='robin'") or die(mysql_error());

//Order By [sorting ASC] Query

$result = mysql_query("SELECT * FROM emp WHERE fieldname='robin' order by fieldname ASC") or die(mysql_error()); 

//Order By [sorting DESC] Query

$result = mysql_query("SELECT * FROM emp WHERE fieldname='robin' ORDER BY fieldname DESC") or die(mysql_error()); 


//Group by Query

$query = mysql_query("SELECT fieldname, MIN(age) FROM emp GROUP BY fieldname") or die(mysql_error());

?>