Posted by Richard Davey on 07/06/05 16:45

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

• Next in forum: Re: [PHP] IBM's Learning PHP Part 1 tutorial.
• Prev in forum: Re: [PHP] IBM's Learning PHP Part 1 tutorial.
• Thread view: Re[2]: [PHP] IBM's Learning PHP Part 1 tutorial.

[Reply to this message]