Re: [PHP-DB] weird string literal related problem

nvm, I got my answer -- foreach ( $entries as $column => $value ) will give the column names .. which simplifies my task a lot. On Mon, Aug 1, 2016 at 12:52 PM, Ratin wrote: > Just curious why the values can only be accessed by column names and not > an array subscript, like :

Re: [PHP-DB] weird string literal related problem

Just curious why the values can only be accessed by column names and not an array subscript, like : $i=0; $result = $db->query('select * from DecoderUser'); while ($entries = $result->fetchArray()) { $value=$entries[i]; $i = $i + 1; } On Mon, Aug 1, 2016 at 12:25 PM, Ratin

Re: [PHP-DB] weird string literal related problem

Thanks Aziz, that works. Somehow i thought the ' needed to be included just like you quote all strings on an interactive DB shell or even when you get the value directly by column name. On Mon, Aug 1, 2016 at 11:47 AM, Aziz Saleh wrote: > But if i print

Re: [PHP-DB] weird string literal related problem

But if i print $entries['decoderUserGUID'] I get the correct value This means the key value is decoderUserGUID NOT 'decoderUserGUID', try creating $strIndex without the quotes, just the key value. On Mon, Aug 1, 2016 at 2:31 PM, Ratin wrote: > Hi I am new to this list, not

[PHP-DB] weird string literal related problem

Hi I am new to this list, not sure how active this list is but i have a question regarding php-sqlite integration. I am using a string variable where I put the column name and trying to use that varible to get its value, in a loop. So here is what I have (simplified version): $strIndex='\'' .