Using php mysql group results by column? [duplicate]

Question

I have a table with data mobile(id, name, size);

(1, "Asha 301", "240 x 400");
(2, "Asha 302", "480 x 800");
(3, "Asha 303", "240 x 400");
(4, "Asha 304", "480 x 800");
(5, "Asha 305", "240 x 400");
(6, "Asha 306", "240 x 400");
<?php
    $query = "SELECT id, name, size
              FROM `mobile`
              GROUP BY size Order by display_size ";
    $results = mysql_fetch_array($query);
   foreach ($results as $result) {
        ?>
        <li>
           <?php echo $result['size']; ?>
           <ul>
               <li><?php echo $result['name']; ?></li>
           </ul>
        </li>
<?php
}
?>

And result is:

240 x 400
   Asha 301
400 x 800
   Asha 302

result only get 1 row, how to get all rows ?

240 x 400
   Asha 301
   Asha 303
   Asha 305
   Asha 306
400 x 800
   Asha 302
   Asha 304

How to fix it ?

See this question: stackoverflow.com/questions/3707613/…

Brian
– Brian

2012-06-13 04:14:07 +00:00
Commented Jun 13, 2012 at 4:14 — Brian
– Brian, Commented Jun 13, 2012 at 4:14

FThompson · Accepted Answer · 2012-06-13 04:01:06Z

1

mysql_fetch_object returns an object, so iterating through it in a foreach does nothing.

Instead, you should use mysql_fetch_array, which returns an array of the results,

answered Jun 13, 2012 at 4:01

FThompson

28.8k13 gold badges63 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

chaitu · Accepted Answer · 2012-06-13 05:01:44Z

1

 $query = "SELECT `id`, `name`, `size` FROM `mobile` Order by `size` ";
 $results = mysql_query($query);
 while ($result=mysql_fetch_array($results)) {
  ?>
    <li>
       <?php echo $result['size']; ?>
       <ul>
           <li><?php echo $result['name']; ?></li>
       </ul>
    </li>

answered Jun 13, 2012 at 5:01

chaitu

5991 gold badge6 silver badges13 bronze badges

1 Comment

mickmackusa Over a year ago

This unexplained snippet clearly does not satisfy the brief of needing the group text once followed by all children of the group.

Collectives™ on Stack Overflow

Using php mysql group results by column? [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related