I am using this query to obtain data from mysql

"select Code_Desc, Code_Type from code order by Code_Type"

Code_Type contains "R" or "P", I want to shown R and P data in two columns, all P Records may be in first column and all R records may be in 2nd columns.
Any idea how to do in php?

PHP Code:

<?php
echo "<table><tr>";

$sql = mysql_query("SELECT Code_Desc, Code_Type FROM code ORDER BY Code_Type");
while($item=mysql_fetch_array($sql))
{
    //$item[0] is the Code_Desc
     if($item[1]=="R")
     {
          echo "<td></td>";//empty the first column which contains P
          echo "<td>echo $item[1]</td>";
     }else if($item[1]=="P")
     {
           echo "<td>echo $item[1]</td>";
           echo "<td></td>";//empty the second column which contains R
     }
}
echo "</tr></table>";
?>

i hope this works!! let me know what you get with this code!!!