Posted by Karl Groves on 03/23/07 13:42

Hendri Kurniawan <ask-me@email.com> wrote in
news:1306k88t4bqh0aa@corp.supernews.com:

> Karl Groves wrote:
>> I'm trying to run mysql_fetch_array with a variable in place of the
>> optional result type constant, like so
>>
>> mysql_fetch_array($result, $rtype) where, obviously, $rtype is one of
>> the three valid values for the result type. This throws an error:
>> "mysql_fetch_array() [function.mysql-fetch-array]: The result type
>> should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH."
>>
>> I'm not quite sure what the issue here is, other than that I'm
>> replacing a constant with a variable. I'm looking for a solution
>> that will allow me to (variably) be able to dictate this value.
>>
>> TIA
>>
>
> I assume your variable $rtype contains string of the constants.
> "MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH" are CONSTANTS.
> As such, $rtype need to contains the value of the constants.
> ie. assign $rtype = MYSQL_NUM *NOT* $rtype = 'MYSQL_NUM'
> (Note the quote)
>

UGH. So simple. Thanks



--
Karl Groves

[Back to original message]