MySQL Query returns null

Linear Mode

Vince
Spam Machine

Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0

24.11.2016, 15:43

Never use num_rows if you merely want a count of something. Use the COUNT() aggregate function instead. Why? In the former case the entire result set is sent. Possibly a few thousand rows. Not efficient. In the latter case the result is always one single field that contains the count.

Find

« Next Oldest | Next Newest »

Messages In This Thread

MySQL Query returns null - by SsHady - 24.11.2016, 15:08

Re: MySQL Query returns null - by Dayrion - 24.11.2016, 15:11

Re: MySQL Query returns null - by SsHady - 24.11.2016, 15:19

Re: MySQL Query returns null - by J0sh... - 24.11.2016, 15:23

Re: MySQL Query returns null - by Dayrion - 24.11.2016, 15:23

Re: MySQL Query returns null - by TwinkiDaBoss - 24.11.2016, 15:24

Re: MySQL Query returns null - by Vince - 24.11.2016, 15:43

Re: MySQL Query returns null - by SsHady - 25.11.2016, 09:58

Re: MySQL Query returns null - by Konstantinos - 25.11.2016, 11:33

Re: MySQL Query returns null - by SsHady - 25.11.2016, 11:38

View a Printable Version

Forum Jump:

Users browsing this thread: 2 Guest(s)

Login
Username:
Password:	Lost Password?
	Remember me