Thread

I’d like to display the total results of a query but it repeats for each result.

{exp:query sql="SELECT vehicles.make, vehicles.model FROM vehicles WHERE vehicles.make = 'Subaru'}
                          
<div class="infomessage">{total_results} Vehicles Match Your Search</div>
    
{/exp:query}

If the query turns out 7 results, it display ‘7 7 7 7 7 7 7’. Is it possible to keep {total_results} from repeating?

Thanks for any help or suggestions.

Patrick

Add a LIMIT to your tag. You are also missing a closing double apostrophe

{exp:query sql="SELECT vehicles.make, vehicles.model FROM vehicles WHERE vehicles.make = 'Subaru' LIMIT 1"}
                          
<div class="infomessage">{total_results} Vehicles Match Your Search</div>
    
{/exp:query}

Thank you for the help.

I did add a limit but then the total ended up being whatever I set my limit to. For anyone else who has the same issue, I found the solution in this thread, which had to do with utilizing the COUNT function in your sql statement.

{exp:query sql="SELECT COUNT(vehicles.model) AS total_vehicles FROM vehicles WHERE vehicles.make = 'Subaru'"}
                          
   <div class="infomessage">{total_vehicles} Vehicles Match Your Search</div>
    
{/exp:query}

😊

Ah yes. My bad. Should have known that. Glad you got it working . Feel free to start a new thread if you have any more questions.