How to get total of table rows?
Posted: Tue Feb 01, 2005 9:40 am
Ok,I've been looking around and I stumbled upon a php mysql command called mysql_num_fields. And it looks like it'll do what I want, I just want to get the total number of rows that are in a table. It looks like how this command works, it actually needs you to get all items in a table, return them and then it totals them up to see how many there are. Is there a faster way? Or is that the wrong way to go with it?
While I'm tapping into your knowledge, is there a way to have mysql just randomly grab a set number of items out of a table?
Tnaks,
Paul
While I'm tapping into your knowledge, is there a way to have mysql just randomly grab a set number of items out of a table?
Tnaks,
Paul