SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in select *,(select name from album where album.id=gallery.album_id) as albumname from gallery where album_id=