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

Sun, 27 February 2011 18:49

bruceaj
Messages: 30
Registered: September 2010

Karma:

Member

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

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:58:39 GMT 2024

Total time taken to generate the page: 0.04750 seconds