Group by value ( remarks ) below tr

[shashib]

Below is products table :

    id | mid | wgh | remark| remkok |
    1    3     1.5    r3ok      1
    2    2     1.5              0
    3    2     0.6    nice      0
    4    1     1.2    okh       0
    5    4     1.5    bye       0
    6    4     2.4    okby      0
    7    3     3.0    oknice    1

I want to display remark below tr of group by mid ....like below

   mid    wgh  
    3     1.5   
          3.0 
  remarks : r3ok, oknice
    4     1.5
          2.4
  remarks : bye, okby
    2     1.5
          0.6
  remarks :  , nice
    1     1.2
  remarks : okh

**What i have tried as below :**

 $pid= null;
    while($row = mysql_fetch_array($result))
    {
   
     $rowpkts =  $row['mid'];
     echo "<tr class=\"undercl\">";
       if($rowpkts != $pid){
             echo'<td align="center" valign="top">'.$row["mid"].'</td>';
      }else{
            echo'<td align="center" valign="top"></td>';
       }
    
       echo'<td align="center" valign="top">'.$row["wgh"].'</td>';
        
      echo "</tr>";

    // what i tried to build for remarks as below

    $remsql = "SELECT mid as onu , GROUP_CONCAT(`remark` ORDER BY `id` ASC  SEPARATOR ', ') AS plrmks
    FROM products  WHERE remkok= 1 GROUP BY  `mid`";
    $fetchremk = mysql_query($remsql);
    $rowresults =  mysql_fetch_array($fetchremk);

     if($rowresults['onu'] ==  $pid ){   

      echo"<tr style='border-style:underline;'>";
           echo'<td align="center" align="top">'.$rowresults["plrmks"].'</td>';               
               echo"</tr>";
            }
      }

      $pid = $rowpkts;
                            
    }

But remarks is not coming proper ...i means its not display below mid=3 or mid=1.....

Edited May 13, 2016 by shashib

[shashib]

any one here ..please help me ...any other solution with other table tr format will help me tooo

[shashib]

i have modified my question ..please see

[dsonesuk]

We are not here 24/7, from what I can see, there is no pattern of sorting to produce that layout order. If it was mid highest to lowest I could get close to what you want, but as it is now, one cancels out the other to produce the correct order.

[shashib]

hey @dsonesuk , thanks for reply ... please help me out what you have in mind ...might it can help me ...basically that remarks row will be seen only when my Column remkok = 1 ... but to explain each point was making my question confusing ..hence i wrote it simple....

 

please help me with your answer

 

Thanks

[dsonesuk]

<?php

// put your code here

$query_producttest = "SELECT * FROM products ORDER BY remkok DESC, mid DESC";

$result = mysql_query($query_producttest, $productconn) or die(mysql_error());

$totalRows_producttest = mysql_num_rows($result);

 

echo $totalRows_producttest;

echo '<table border="1" cellpadding="5" cellspacing="0" style="width: 400px;">';

echo '<th>id : mid</th><th>wgh</th>'; //<th>remkok</th>';

$pid = null;

$join_array = [];

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

 

if ($row['mid'] !== $pid && $pid !== null) {

echo get_remarks(implode(', ', $join_array[$pid]));

}

 

echo "<tr class=\"undercl\">";

if ($row['mid'] !== $pid) {

echo'<td align="center" valign="top">' /* .$row["id"] . ' : ' */ . $row["mid"] . '</td>';

} else {

 

echo'<td align="center" valign="top"></td>';

}

$pid = $row['mid'];

echo'<td align="center" valign="top">' . $row["wgh"] . '</td>';

 

if ($row['mid'] === $pid) {

 

$join_array[$row["mid"]][] = '  ' . $row["remark"];

}

//echo'<td align="center" valign="top">' . $row["remkok"] . '</td>';

 

echo "</tr>";

 

$pid = $row['mid'];

}

echo get_remarks(implode(', ', $join_array[$pid]));

echo '</table >';

 

function get_remarks($arr_value) {

return '<tr><td colspan="3" align="center" valign="top"> Remarks : ' . $arr_value . '</td></tr>';

}

 

var_dump($join_array);

?>

[shashib]

hey @dsonesuk, thanks you very much , have tried your above code ....and its working ... will implement it fully with my all conditions ....

 

thanks once again

[shashib]

hey dude,

 

And what if i need as below, as i tried to build in your above query ...but i failed .....

    id | mid | wgh | remark| remkok | name |
    1    3     1.5    r3ok      1     name1
    2    2     1.5              0     name3
    3    2     0.6    nice      0     name3
    4    1     1.2    okh       0     name4
    5    4     1.5    bye       0     name2
    6    4     2.4    okby      0     name2
    7    3     3.0    oknice    1     name1

mid  wgh 
3    1.5 
     3.0
remarks : NAME1 - r3ok, oknice
4    1.5
     2.4
remarks : NAME2 - bye, okby
2    1.5
     0.6
remarks : NAME3 - , nice
1    1.2
remarks : NAME4 - okh

Edited May 16, 2016 by shashib

[dsonesuk]

you will need to make sure the first value is the name

 

$join_array[$row["mid"]][0] = strtoupper($row['name']) . ' - ';