Pivot table

[Ritika]

PLEASE help................

 

 // I am getting output like 

/*

 

 * Date     |NAME      | Roll_no  |  ATTEND

   ========================================

   01/02/14 |Musician  |   1     |    1

   01/02/14 |Leader    |   2     |    1

   01/02/14 |Singer    |   3     |    0

   08/02/14 |Musician  |   4     |    0

   08/02/14 |Leader    |   5     |    1

   08/02/14 |Singer    |   6     |    1

 *

 */

/* NEEDED sample output:

  *

  * Roll_no |   NAME     |01/02/14  |08/02/14

    ===============================

       1    |Musician    |   0      |  1

       2    |Leader      |   1      |  1

       3    | Singer     |   1      |  0

  */

here is my code --

{

<?php

include('config.php');

 

$sql = ("SELECT roll_no,attend,date from atten ") ; 

$q1 = mysql_query($sql) or die("could not search!");

echo "<table border='1'>";

                echo "<tr>

                        <td>roll_no </td>

                        <td> attendance</td>

                        <td> Date </td>

                      </tr>" ;

 

 

            while ($row=mysql_fetch_array($q1)) {

                echo "<tr>

                        <td>". $row['roll_no'] ." </td>

                        <td>". $row['attend'] ." </td>

 

 

                        <td>". $row['date'] ." </td>

                      </tr>";  

            }               

            echo "</table>"; 

 

?>

}

Edited March 9, 2016 by Ritika

[samuel_lopez]

You should group your query by name

[Ritika]

I want to do it with PHP ..  thanks 

[ginerjm]

Funny post. You show us one set of data and then show us code that doesn't match it. Confusing.