Re[2]: [PHP] IBM's Learning PHP Part 1 tutorial.
| From: | Richard Davey | Date: | Wed, 06 Jul 2005 13:45:47 +0000 |
| Subject: | Re[2]: [PHP] IBM's Learning PHP Part 1 tutorial. | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-218203@lists.php.net to get a copy of this message | ||
Hello André,
Wednesday, July 6, 2005, 3:25:37 PM, you wrote:
AM> Depending on the sittuation, IMHO, COUNT(*) wouldn't be the way to
AM> go. If you need the user's id or somesuch, you have to run an
AM> additional query to get the info.
But they're returning absolutely nothing in this case - which
(providing username was indexed) would make count() a far quicker and
less expensive query than selecting and bring back data and then doing
absolutely nothing with it (somewhat pointless imho)
Best regards,
Richard Davey
--
http://www.launchcode.co.uk - PHP Development Services
"I do not fear computers. I fear the lack of them." - Isaac Asimov