FUDforum: comp.lang.php » ODBC Connection

Home » Imported messages » comp.lang.php » ODBC Connection

Show: Today's Messages :: Polls :: Message Navigator

Re: ODBC Connection [message #172744 is a reply to message #172743]

Sun, 27 February 2011 20:06

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

On Sun, 27 Feb 2011 14:51:07 -0500, Jerry Stuckle wrote:

> On 2/27/2011 2:19 PM, richard wrote:
>> On Sun, 27 Feb 2011 10:49:26 -0800 (PST), bruceaj wrote:
>>
>>> On Feb 27, 1:36 pm, richard<mem...@newsguy.com> wrote:
>>>> On Sun, 27 Feb 2011 09:57:11 -0800 (PST), bruceaj wrote:
>>>> > I am connecting to an MS Access database. The connection and exec work
>>>> > fine. My problem is getting the data.
>>>>
>>>> > The following two statement work;
>>>> > $row = odbc_fetch_array($rs);
>>>> > $value = $row['Newspaper'];
>>>>
>>>> > If I change to
>>>> > $value = $row[1];
>>>>
>>>> > is_null($value) returns true.
>>>>
>>>> > What am I doing wrong or is an idiosyncrasy of using MS Access?
>>>>
>>>> > Bruce
>>>>
>>>> I'd say it's due to the fact you did not define $row[1].
>>>> Instead, you used 'newspaper' as the row identifier.
>>>> It can't find [1] so it reports an error.
>>>
>>> Okay??? I guess I don't know what I thought I knew!!
>>>
>>> Doesn't "odbc_fetch_array" returns an associative array. If so, can't
>>> I address the elements either by name "newspaper" or by index "1".
>>>
>>> One minor point, the index I should be using is "0" since the
>>> associative array is 0 based.
>>>
>>> Appreciate some suggestions on what I need to address the elements of
>>> my array, $row, via an index value.
>>>
>>> Thanks again...
>>>
>>> Bruce
>>
>> as I understand it, the array contents have to be defined.
>> If you define an array with names rather than number, then you can not
>> assume 0 is going to be the first array item. Or that 0 will be associated
>> with the first item by default.
>>
>> $item[0]="aaa"
>> $item[1]="bbb"
>> $item['sample']="ccc"
>> $item['data']="data"
>> $item[2]="ddd"
>>
>> If I wanted to recall the third item in the array, I would have to use
>> ['sample'] not [2].
>> If [2] did not exist, I can not assume [2] would equate to ['sample'].
>>
>> IOW, what you defined in the array, is what can be recalled.
>
> Richard, odbc_fetch_array() IS defining the array. Just not the way he
> expects.

okay thanks.

Report message to a moderator

[Message index]

		ODBC Connection By: bruceaj on Sun, 27 February 2011 17:57
		Re: ODBC Connection By: Luuk on Sun, 27 February 2011 18:07
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 18:24
		Re: ODBC Connection By: Jerry Stuckle on Sun, 27 February 2011 18:54
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 20:46
		Re: ODBC Connection By: Jerry Stuckle on Sun, 27 February 2011 20:55
		Re: ODBC Connection By: spambait on Sun, 27 February 2011 21:02
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 21:10
		Re: ODBC Connection By: Luuk on Sun, 27 February 2011 19:04
		Re: ODBC Connection By: richard on Sun, 27 February 2011 18:36
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 18:49
		Re: ODBC Connection By: richard on Sun, 27 February 2011 19:19
		Re: ODBC Connection By: Jerry Stuckle on Sun, 27 February 2011 19:51
		Re: ODBC Connection By: richard on Sun, 27 February 2011 20:06
		Re: ODBC Connection By: sheldonlg on Sun, 27 February 2011 20:52
		Re: ODBC Connection By: P E Schoen on Mon, 28 February 2011 07:47
		Re: ODBC Connection By: Jerry Stuckle on Mon, 28 February 2011 11:40
		Re: ODBC Connection By: P E Schoen on Mon, 28 February 2011 18:48

Previous Topic:	static vs global variable
Next Topic:	SOCIAL NETWORK FOR PHP PLATFORM..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 20:45:38 GMT 2024

Total time taken to generate the page: 0.05143 seconds