Hi,
I want to make a select from mysql to show some data in page.
To show a table with data from mysql but limited to only 5 and this to show total number of rows.
I'm thinking to make two selects.
SELECT count(*) FROM table1 and after that to use mysql_num_rows to count total number in that table.
Then another SELECT name,prename FROM table1 LIMIT 1, 5 to show only first 5 rows.
It's there a way to use only one select insted of two but having the same results ?
Thanks