A.Ichi score 3925
2017/02/23 13:55 投稿
| JOINしてLOOPして表示します。 |
| ```php |
| $st = $pdo->query("SELECT name, car_name FROM 車種 INNER JOIN 社名 ON car_id=id ORDER BY name"); |
| $s_name=""; |
| while($result=$st->fetch(PDO::FETCH_ASSOC)){ |
| if ( $s_name != $result["name"] ){ |
| echo "<br>\n"; |
| echo $result["name"]; |
| }else{ |
| echo ","; |
| } |
| $s_name = $result["name"]; |
| echo $result["car_name"]; |
| } |
| echo "<br>\n"; |
| ``` |
