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
// second argument is the row offset, and the third argument is the
$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
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php