Hi,

I created query to display the reject acronym and reject name.

here is my code:

PHP Code:
  
            $sql_reject 
"select r.reject_acro, r.reject_id, r.reject_name from process_list AS p LEFT JOIN reject_list AS r ON 
p.reject_id = r.reject_process_id
 where p.process_name LIKE '" 
. ($_POST["id"]) . "%'";
 
           
$res_reject mysql_query($sql_reject);
           echo 
"<table>";
           while(
$row_reject mysql_fetch_assoc($res_reject)){
               
$acro        $row_reject['reject_acro'];
               
$reject_name $row_reject['reject_name'];
            
            echo 
"<tr>";
            echo 
"<td>$acro</td>";
            echo 
"<td>$reject_name</td>";
            echo 
"</tr>";     
               
            }
           echo 
"</table>"
and my data in my database is this:

reject_acro|reject_name
AA---------Ant
BB---------Bee
CC---------Cat
DD---------Dog
EE---------Elephant
FF---------Frog
GG--------Goat
HH--------Horse
KK---------Kangaroo

now in this code the output is the same above

but i want it to display like this: I want to display in for columns

AA|Ant|BB|Bee|CC|CatDD|Dog|
EE|Elephant|FF|Frog|GG|Goat|HH|Horse
KK|Kangaroo

Thank you