using pg_field_is_null() from Postgres
Posted: Fri Mar 04, 2005 10:33 am
I'm attempting to test for null values, using postgres and php
This gives me the error: Warning: pg_field_is_null(): Unable to jump to row 0 on PostgreSQL result index 11 in /var/www/html/reg/stats.php on line 139, which is this line:
if (pg_field_is_null($result22, 0, "frequency") == 1) {
thanks for any help!
Dinesh
Code: Select all
$query22 = "select frequency, count(access) from reg.rur where app=2 and access='local' group by frequency";
$result22 = pg_query($connection, $query22) or die("0");
if (pg_field_is_null($result22, 0, "frequency") == 1) {
echo "No users run local copies of this software";
}
$arr8 = pg_fetch_array($result22, 0, PGSQL_NUM);
echo "Frequency of use for ArcMap users: $arr8ї0]. Use a local copy: $arr8ї1]";if (pg_field_is_null($result22, 0, "frequency") == 1) {
thanks for any help!
Dinesh