DHara: mysql - Display total records found

Sunday, 15 May 2011

Well I have a query that gives me some records.

  $ sql = "SELECT * FROM Tablename WHERE ..... LIMIT $ limit"; // Getting dynamic range value

This gives me

  $ sql = "SELECT * FROM Tablename WHERE ..... LIMIT 61,10"; $ Race = parent: _ executeQuery ($ SQL); $ R = parent: getAll ($ race); $ Refund;

There are 61 records in total, out of which only 10 records are returning. I need to display total records. I, e 61 in my HTML file.

How do I get total records? "SELECT COUNT (*)" If you want to limit the results set by using LIMIT, you can select "SELECT COUNT (*)".

DHara