Looking for Documentation On PHP and ODBC

Posted on 2008-11-17
Last Modified: 2013-12-13
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?

Question by:shacho

    Author Comment

    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.
    LVL 20

    Accepted Solution

    Your right it is not an error but a pointer to your open connection.

    (example text taken from )

    $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";

    LVL 36

    Expert Comment

    by:Loganathan Natarajan

    Author Comment



    Featured Post

    Easy Project Management (No User Manual Required)

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now