: update e_xoops_myalbum_photos set hits=hits+1 where lid= and status>0

: select l.lid, l.cid, l.title, l.ext, l.res_x, l.res_y, l.status, l.date, l.hits, l.rating, l.votes, l.comments, t.description from e_xoops_myalbum_photos l, e_xoops_myalbum_text t where l.lid= and l.lid=t.lid and status>0

: SELECT * FROM e_xoops_myalbum_comments WHERE item_id= ORDER BY date DESC