Let's say I have a database of book entries and I want to only retrieve the first 50 that have a certain author, even though there are more than 200 of them. What I'd like to output is a message saying, "Your search found 2xx results. Here are the first 50"
Is there a way to do this in one mysql query? I know how to do it in two queries, a SELECT...LIMIT 50, and a COUNT query.
Is there a way to do this in one mysql query? I know how to do it in two queries, a SELECT...LIMIT 50, and a COUNT query.
