php mysql select data to gridview

Question

when select data from database using php-mysql and display in html table it shows as (A).

but i want to display it as (b)

help me...

What? Please updated your question with expected output and a better explanation — sagi, Feb 16 '16 at 08:13
Yes, you can achieve this. As said by Sagi, do update you question with more details. — PHPExpert, Feb 16 '16 at 08:16
I think I understand what you're trying to achieve (exclude the repeating Dates and Nums from the rows), but you have to show us PHP code that handles the output so that useful suggestions could be made. — Sergey Vidusov, Feb 16 '16 at 08:21
Look for `GROUP_CONCAT()`, there are a lot of questions similar to this. (Like http://stackoverflow.com/questions/13451605/how-to-use-group-concat-in-a-concat-in-mysql) — phaberest, Feb 16 '16 at 08:32
http://www.w3resource.com/mysql/aggregate-functions-and-grouping/aggregate-functions-and-grouping-group_concat.php — Rahul, Feb 16 '16 at 08:44

score 3 · Accepted Answer · answered Feb 16 '16 at 08:47

Sample (and very simple) code would be:

// assuming the PDO connection is established and kept in $db
$st = $db->prepare("SELECT Date, Num, Value1, Value2 FROM the_table");
if ($st->execute()) {
    $previousDate = NULL;
    $previousNum = NULL;
    while ($row = $st->fetch()) {
        echo '<tr>';
        echo '<td>';
        if ($previousDate != $row['Date']) {
            echo $row['Date'];
            $previousDate = $row['Date'];
        }
        echo '</td>';
        echo '<td>';
        if ($previousNum != $row['Num']) {
            echo $row['Num'];
            $previousNum = $row['Num'];
        }
        echo '</td>';
        echo '<td>'. $row['Value1'] .'</td>';
        echo '<td>'. $row['Value2'] .'</td>';
        echo '</tr>';
    }
}

php mysql select data to gridview

1 Answers1