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 #172739 is a reply to message #172734]

Sun, 27 February 2011 19:19

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

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.

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 18:45:05 GMT 2024

Total time taken to generate the page: 0.04066 seconds