Kirk Wythers wrote:
I am having trouble with a db query that was working not too long ago. I did upgrade from php4 to php5 and wonder if there are some differences that could explain my issue. Below is the code where I suspect things are breaking down.

// build sql query from form values
$select_query = "select * from grid_cell where township = $township
and range = $range and rdir_shortname = '$rdir_shortname'
and section = $section and forty_name = '$forty_name'";
//echo $select_query; // use for debugging sql query

// retrieve the query info from postgresql
//this returns a resource, so put the resource into a variable
$result = pg_query($select_query);
//echo $result; // use for debugging sql query

// process results. First argument pg_result is the returned result set ($grid_cell), // second argument is the row offset, and the third argument is the column offset.
$forty_grid = pg_result($result, 0, 0);
//echo $forty_grid; // use for debugging sql query

If I uncomment echo $select_query, the scrip prints the proper query like this:

select * from grid_cell where township = 67 and range = 1 and rdir_shortname = 'W' and section = 1 and forty_name = 'NWNW'

However, if I uncomment echo $result, the script prints:

Resource id #2

and also the error:

Unable to jump to row 0 on PostgreSQL result index 2

I think that the variable $result is getting the result from pg_query and subsequently $forty_grid is not receiving what it expects either.

Does anyone see what I'm not doing right here?

Just because the query returned a resource ID does not mean it contains any results. An empty result set is what you're getting, and you need to check for that before trying to use the results.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to