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

Sun, 27 February 2011 18:54

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

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())/

--
==================
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 11:26:15 GMT 2024

Total time taken to generate the page: 0.04035 seconds