When displaying the total records among these ,i want to count of commets field,how to get\[code\]SELECT s.id, s.album_title, q.file_name, s.views, a.commentsFROM photo_albums s RIGHT JOIN photos q ON s.id = q.album_id LEFT JOIN photo_comments a ON q.album_id = a.photo_idORDER BY s.createdon DESC\[/code\]
Display the records by using mysql
- Thread starter LinNnDi
- Start date