Re: Help w/ a Query

2004-01-21 Thread Roger Baklund
* jalil > I need to get total number of all rows in a table and also select some > rows from the same table. I know how to do this > using two queries, but was wondering if there is any way to do it in one > query (one trip to the database). >From version 4 you can use the SQL_CALC_FOUND_ROWS opti

Help w/ a Query

2004-01-21 Thread jalil
I need to get total number of all rows in a table and also select some rows from the same table. I know how to do this using two queries, but was wondering if there is any way to do it in one query (one trip to the database). Thanks, -Jalil -- MySQL General Mailing List For list archives: htt