MySQL存储函数和php

Question

So i have this query to fetch all posts

select id, title 
from posts 
where type = 'article'

and i have a stored function that calculate the total of views and return the result

i know i can execute it like

select totalView(id)

but how can i merge the two queries to return all posts with the total view of each post

maybe something like

select id, title, totalView(id) as total 
from posts 
where type = 'article'

Thank you.

Answer 1

select count(*) as total, id, title from posts where type = 'article'

EDIT : It will count all the rows of $id

select count(*) as total, id, title from posts where type = 'article' AND id = $id;