Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    26

    Unanswered: Unable to jump to row 0

    Hello
    I'm working with postgre 7.2.1 and php 4.1.2
    I've been working ok for 15 days. Now when I do a ph_fetch_array I get the following error:

    Warning: Unable to jump to row 0 on PostgreSQL result index 2

    the line of code in php is:
    $this->row = pg_fetch_array($query_id, $this->rownum[$query_id]);

    // $this->rownum[$query_id] represents 0 and the $query_id seems to be correct.

    Any idea?

  2. #2
    Join Date
    Aug 2003
    Posts
    32
    Does the query actually return any rows?

    What does pg_num_rows($query_id) return?

  3. #3
    Join Date
    Jan 2004
    Posts
    26
    Originally posted by stacey_richards
    Does the query actually return any rows?

    What does pg_num_rows($query_id) return?
    it returns 0, but if I execute the same query on pgAdmin, the query returns 1 row.

  4. #4
    Join Date
    Jan 2004
    Posts
    26
    There is no more problem. All this has been caused by a postgre Manager that seems it was bringing data from memory and not from server. The truth of all it's tha there where no records and php was working ok.
    Sorry about it.
    The Postgre Manager I've been using it's EMS PostreSql Manager. Seems to be good but not so good. I had to use phpPgAdmin to realize what the problem was.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •