Length of database result without using count?

Question

Possible Duplicate:
How can I count the numbers of rows that a mysql query returned?

To get the length of the return of a mysql result, I am using:

$counter=0;
while($row = mysql_fetch_array($mysqlqueryresult)){
$counter++;
}
echo $counter;

Is there a better way to get the number of rows returned by mysql?

Note - Not allowed to use COUNT in the mysql or any mysql tricks, only php on the mysql output as here. So starting point is a mysql returned thing of $mysqlqueryresult; which itself is the result of a basic SELECT query.

@Michael, it's easy to search for the answer if you already know the answer. — Paul Tomblin, Jan 08 '12 at 13:28

score 7 · Accepted Answer · answered Jan 08 '12 at 13:16

7

Use mysql_num_rows.

$counter = mysql_num_rows($mysqlqueryresult);

If you've updated the table, the number of affected rows is given by mysql_affected_rows.

answered Jan 08 '12 at 13:16

Rob W

341,306
83
791
678

This is one of those instances where the question has been asked so many times it becomes impossible to find a dulicate to link. – Michael Berkowski Jan 08 '12 at 13:18

score 2 · Answer 2 · answered Jan 08 '12 at 13:16

2

Use mysql_num_rows($mysqlqueryresult)

answered Jan 08 '12 at 13:16

Nikoloff

4,050
1
17
19

score 0 · Answer 3 · answered Jan 08 '12 at 13:17

0

mysql_num_rows() is the function you're looking for.

edit. I arrived too late. ;)

answered Jan 08 '12 at 13:17

Nicola Cossu

54,599
15
92
98

score 0 · Answer 4 · answered Jan 08 '12 at 13:21

0

you Can use mysql_num_rows() routine .

$counter = mysql_num_rows($mysqlqueryresult);

answered Jan 08 '12 at 13:21

Vijeenrosh P.W

359
1
3
8

score 0 · Answer 5 · answered Jan 08 '12 at 13:23

0

Well, just for the method's sake (although mysql_num_rows() is the preferred method), a pure php one without using a loop:

count($mysql_fetch_array($mysqlqueryresult));

(or am I completely mistaken?)

answered Jan 08 '12 at 13:23

alex

1,277
3
14
30

Length of database result without using count?

5 Answers5