FuelPHP Forums

Huzzi

I think it would it be useful to include a method in the db class to get the total number of rows before applying the offset and limit filter.. an example would be in passing total number of records to the pagination config variable without querying the database twice. What do you guys think?

huglester

hey,
there is smth like this: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows I think it should work for you. Not sure how much SQL queries it will cost .. Not tested

Dregond Rahl

wouldn't the count() method work to get the total rows ? Edit: DB::expr(), DB::count_records, and a few others might help, its in the Docs.

FrenkyNet

If I were you, I'd look into DB::count_last_query http://fuelphp.com/docs/classes/database/db.html#method_count_last_query

Huzzi

Thanks FrenkyNet

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion