Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 10th, 2012  |  syntax: None  |  size: 0.91 KB  |  hits: 7  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Error group by on id in php mysql?
  2. brand(id, name)
  3.      (1, 'Apple')
  4.      (2, 'Dell')
  5. model(id, name, brand_id)
  6.      (1, 'Macbook', 1)
  7.      (2, 'Iphone', 1)
  8.      (3, 'Vostro', 2)
  9.        
  10. <?php
  11. // Make a MySQL Connection
  12. $query = "SELECT * FROM model";  
  13. $result = mysql_query($query) or die(mysql_error());
  14. $row = mysql_fetch_array($result) or die(mysql_error());
  15. $brand_id = array();
  16. $brand_id = array_unique($row['brand_id']);
  17. ?>    
  18. <table>
  19.     <?php for($i=0; $i<count(brand_id); $i++) {?>
  20.     <tr>
  21.         <td><?php echo $row['name'] ?></td>
  22.     <tr/>
  23.     <?php }?>
  24. </table>
  25.        
  26. <table>
  27.    <tr><td>Macbook, Iphone, Vostro</td></tr>
  28.    <tr><td>Macbook, Iphone, Vostro</td></tr>        
  29. </table>
  30.        
  31. <table>
  32.    <tr><td>Macbook, Iphone</td></tr>
  33.    <tr><td>Vostro</td></tr>        
  34. </table>
  35.        
  36. SELECT  GROUP_CONCAT(b.`name`)
  37. FROM    brand a
  38.             INNER JOIN model b
  39.                 on a.id = b.brand_id
  40. GROUP BY a.`Name`