Select from a table the same fields.

[wearekda]

Hello everybody,I am new to php, I have created a table in my database it's name is users

the table contains name of the user and his job, I want to create a php page that shows me the same jobs in a row and the other same jobs in another row for example 

 

Jhon=doctor

Mark=engineer

Kevin=engineer

Alex=teacher

Dani=doctor

Adam=teacher

 

and the result

Dr.                                  Eng.                             Mr.

 

Jhon                               Mark                            Alex

Dani                               Kevin                           Adam

 

So how to make it?

 

Thanks 

 

[ThLoser]

use SORT BY jobs in SQL?

[l3rodey]

mysql_query or mssql_query depending on your database if it's mysql or micosoft sql for this demo I will us MySQL.

 

<table>
  <tr>
    <td>MR</td>
    <td>Teacher</td>
    <td>Dr</td>
  </tr>
  <tr>
   <?php
$query = mysql_query("SELECT * FROM users WHERE job='Mr' ORDER BY name");
while($row = mysql_fetch_array($collect_folders)){
$name = $row['name'];
echo '<td>' . $name . '</td>';
}
?>
    <?php
$query = mysql_query("SELECT * FROM users WHERE job='Teacher' ORDER BY name");
while($row = mysql_fetch_array($collect_folders)){
$name = $row['name'];
echo '<td>' . $name . '</td>';
}
?>
    <?php
$query = mysql_query("SELECT * FROM users WHERE job='Dr' ORDER BY name");
while($row = mysql_fetch_array($collect_folders)){
$name = $row['name'];
echo '<td>' . $name . '</td>';
}
?>
  </tr>
</table>

 

You will need to make heaps of changes but this will work, surely someone has something better but this does the trick.

Edited June 26, 2013 by l3rodey