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 #172747 is a reply to message #172745]

Sun, 27 February 2011 20:55

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 2/27/2011 3:46 PM, bruceaj wrote:
> On Feb 27, 1:54 pm, Jerry Stuckle<jstuck...@attglobal.net> wrote:
>> On 2/27/2011 1:24 PM, 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
>>
>> Which is exactly what you should get if you fetch as an associative
>> array. If you want to access the values by index, you need to fetch
>> with an indexed array (odbc_fetch_row())/
>>
>
> Okay.. obdc_fetch_row() seems to have worked. I was under the opinion
> that with an Associative Array the item could be addressed via either
> a name or an index. I guess I'm wrong. Apparently an Associative Array
> can only be indexed via a string value. Strange...
>
> Thanks...
>
> Bruce

No, there are two different kinds of arrays.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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: Wed Nov 27 13:39:16 GMT 2024

Total time taken to generate the page: 0.03943 seconds