Re: Another PDO ?

On 9/10/2012 10:53 AM, Graham H. wrote:

I think it's so that you could write functions as generically as possible. So you don't have to pass in the number of columns or hard code in values for number of columns, you can dynamically check the column count for each result set that gets passed in. That's my guess. On Mon, Sep 10, 2012 at 8:51 AM, Jim Giner <jim.giner@albanyhandball.com>wrote:

On 9/10/2012 10:49 AM, Bastien Koert wrote:

On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner <jim.giner@albanyhandball.com> wrote:

Reading up on the pdostatement class. Wondering what the intent of the columnCount function is. I mean, aren't the number of columns in a result known when you write the query? Granted, you might have some very complex query that you may not know the number, but for most queries you will know the columns you are expecting. So - what am I not seeing? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

It might be for those cases where you run a select * from ... But - again - one already knows how many fields are in that table when

one writes the query... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

I have not yet had a design where the results of queries could be handled generically. Yes I may save some coding time in one way, but for each field in a result the handling is not usually the same, therefore my code would have to specify unique field names at some point. This would only apply to a query that used * instead of distinct names too.

To me it seems a function with rather limited use.