• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Looking for Documentation On PHP and ODBC

I am new to PHP but I get it.  I am trying to connect to an Access DB via ODBC and have mostly been successful, but the debugging process is painful because I can't seem to find any documentation to explain some of the errors I encounter, for example "Resource ID #7".  What does that mean?  Can somebody point me toward a reference that explains these "resource ids" and the like?

  • 2
1 Solution
shachoAuthor Commented:
I should add that I realize that "Resource ID ???" may not be an error but a datatype - still I can't seem to find any references.
Your right it is not an error but a pointer to your open connection.

(example text taken from
http://www.w3schools.com/PHP/php_db_odbc.asp )

$sql="SELECT * FROM customers";

At this point rs is a resource.  I assume you are trying to do echo "$rs" or something similar.

First you need to pull up a row :


Then take the data out of a field inside that row (or record) :

echo "$compname";

Loganathan NatarajanLAMP DeveloperCommented:
shachoAuthor Commented:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now