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 #172736 is a reply to message #172728]

Sun, 27 February 2011 19:04

Luuk
Messages: 329
Registered: September 2010

Karma:

Senior Member

On 27-02-11 19:24, bruceaj wrote:
> On Feb 27, 1:07 pm, Luuk <L...@invalid.lan> wrote:
>> On 27-02-11 18:57, 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
>>
>> This would probably tell more:
>> print_r($row);
>>
>> --
>> Luuk
>
> Okay.. Thanks for the response.
>
> Array ( [Newspaper] => Review [Year] => 1887 [Month] => 5 [Day] => 20
> [Page] => 4 [Column] => 3 [Father First] => Joe [Father Middle] =>
> [Mother First] => [Mother Middle] => [Mother Maiden] => [First] =>
> Daughter [Middle] => [Last] => Allen [Date Of Birth] => 05/18/1887
> [Date Of Baptism] => [Church] => [Counter] => 1 [NewspaperKey] => 1
> [Comments] => )
>
> Hope this helps..
>
> Thanks again.
>
> Bruce

http://www.php.net/manual/en/language.types.array.php

--
Luuk

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:59:59 GMT 2024

Total time taken to generate the page: 0.04912 seconds