Steve Manes <smanes@magpie.com> writes:
$query = "SELECT get_user_data('$cursor', $user_id);FETCH ALL IN $cursor;";
$res =& $dbh->query($query);
Hm. This will return two different, not-compatible result sets (the SELECT's output and then the FETCH's).
Without the FETCH in that compound PHP query however, nothing gets returned from the SELECT. I'm not sure why but maybe it's because PEAR::DB doesn't have any direct support for cursors so it's just grabbing a result set.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings