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

Sun, 27 February 2011 18:36

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

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.

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 19:01:02 GMT 2024

Total time taken to generate the page: 0.07193 seconds