mysql_num_rows vs. mysql_numrows

Question

Please redirect me if this question has already been answered.

I have been managing a legacy system, and I have noticed they use the call mysql_numrows instead of mysql_num_rows. I have spent a decent amount of time searching for documentation on these calls, but have turned up nothing. The system works fine, and I have found no evidence of custom functions for this.

Does anyway know whether this is a deprecated function from an older version of PHP? When I am adding to the system I use mysql_num_rows, which as works fine.

Yes I know that mysql_* is outdated and the system should be updated, but that is beyond the scope of my services. I am mainly just curious why this works? Thanks.

Check to see if they defined their own functions as wrappers — John Conde, Jan 21 '14 at 21:18
@sircapsalot: "because mysql_numrows is not a function" --- is not a built-in function — zerkms, Jan 21 '14 at 21:20
Try this to find out where is it: [How to find out where a function is defined][1] [1]: http://stackoverflow.com/questions/2222142/how-to-find-out-where-a-function-is-defined — CappY, Jan 21 '14 at 21:22

Florian Bussmann · Answer 1 · 2014-01-21T22:09:37.480

7

mysql_numrows is a deprecated alias for mysql_num_rows.

For backward compatibility, the following deprecated alias may be used: mysql_numrows()

Found it here.

edited Jan 21 '14 at 22:09

answered Jan 21 '14 at 21:23

Florian Bussmann

436
3
10

score 4 · Accepted Answer · answered Jan 21 '14 at 21:25

4

mysql_numrows() is an alias for mysql_num_rows() used for backward compatibility.

Look at the following documentation - http://us1.php.net/mysql_num_rows

For backward compatibility, the following deprecated alias may be used: mysql_numrows()

Hope this helps clarify your question.

I'd suggest using mysql_num_rows() where possible, in case this backward compatibility will be ignored in future versions.

Cheers!

answered Jan 21 '14 at 21:25

dev7

6,259
6
32
65

Thank you so much for clarifying this. This is what I assumed, but didn't notice this note in the documentation. – aray12 Jan 23 '14 at 21:09

tnash · Answer 3 · 2014-01-22T21:06:49.100

1

Thats an alias of mysql_num_rows. ~~See PHP documentation http://www.php.net/manual/en/function.msql-numrows.php~~

edited Jan 22 '14 at 21:06

answered Jan 21 '14 at 21:23

tnash

385
4
12

1

That's `msql_`, not `mysql_`. – Cat Jan 21 '14 at 22:08
Ya that I found that one relatively quickly, but I am using mysql which has been pointed out – aray12 Jan 23 '14 at 21:09

mysql_num_rows vs. mysql_numrows

3 Answers3