mysql select id title album_id from gallery_img WHERE user_id ---- ---

mysql> select id,title,album_id from gallery_img WHERE user_id=1;
+----+------------+----------+
| id | title      | album_id |
+----+------------+----------+
|  1 | drink      |        1 | 
|  2 | seda       |        2 | 
|  3 | seda1      |        2 | 
|  4 | seda1333   |        2 | 
|  5 | sdfsdf     |        2 | 
|  6 | sdfsdfw    |        2 | 
|  7 | asdfsdfw   |        2 | 
|  8 | asdfsdfwq  |        2 | 
|  9 | 123        |        2 | 
| 10 | fsdfsdf    |        2 | 
| 11 | fsdfsdf123 |        2 | 
| 12 | fsdfsdf123 |        2 | 
| 13 | logo       |        1 | 
+----+------------+----------+
13 rows in set (0.00 sec)



mysql> select id,title,album_id from gallery_img WHERE user_id=1 GROUP BY album_id;
+----+-------+----------+
| id | title | album_id |
+----+-------+----------+
|  1 | drink |        1 | 
|  2 | seda  |        2 | 
+----+-------+----------+
2 rows in set (0.00 sec)