Fetch the data from database table column and display in PHP table row wise

[Senthilkumar]

Dear Team,

I am having Mysql databse table in the name of fieldtable. My table looks bellow image

I want to fetch the data from this table where the value is 1 and display on my PHP table row wise

How cani display the data like above picture. Can any one help me this

[Barand]

If you had normalized your tables correctly you would already have the data in this format

SELECT id
     , name 
     , month
     , 'Field1' as field
FROM senthil
WHERE field1 = 1
  UNION
SELECT id
     , name 
     , month
     , 'Field2' as field
FROM senthil
WHERE field2 = 1
  UNION
SELECT id
     , name 
     , month
     , 'Field3' as field
FROM senthil
WHERE field3 = 1
  UNION
SELECT id
     , name 
     , month
     , 'Field4' as field
FROM senthil
WHERE field4 = 1
ORDER BY id, field

 

[Barand]

Alternative php solution

$res = $pdo->query("SELECT id
                         , name 
                         , month
                         , field1
                         , field2
                         , field3
                         , field4
                    FROM senthil
                    ORDER BY id
                   ");
$tdata = '';
foreach ($res as $r)  {
    $flds = array_slice($r,3);
    foreach ($flds as $k => $v)  {
        if ($v)  {
            $tdata .= "<tr><td>{$r['name']}</td><td>{$r['month']}</td><td>$k</td></tr>\n";
        }
    }
}

 

[Senthilkumar]

Dear Barand,

 

Thanks for your support. it is working ap per my requirement