using pg_fieldisnull

From: "Christopher Smith" <csmith(at)gio(dot)com(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: using pg_fieldisnull
Date: 2000-07-12 23:27:53
Message-ID: 4A25691A.0080A609.00@g000600.gio.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

Just wondering if anyone can give me some examples on how to use pg_fieldisnull.
This is the reason why.. Currently I have this loop set up to get all data from
a database (I'm just doing a simple one at the moment until I can teach myself
some more :)..). I figure there's a lot better way to do this using
pg_fieldisnull or some other means.

$numrows = pg_numrows($result);
$row=0;
printf ("<table border=1>\n");
printf ("<tr><td>ID</td><td>First Name</td><td>Surname</td></tr>\n");
do
{
$myrow = pg_fetch_row ($result,$row);
printf ("<tr><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow[0], $myrow[1],
$myrow[2]);
$row++;
}
while ($row < $numrows);

it doesn't nescessarily have to put it into a table, so formatting it isn't a
problem. Any suggestions? I know there's a better way to do this, but I can't
think of it :(
I'm using pgsql6.5.3 and php4.

Thanks,
Chris.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2000-07-13 09:44:58 Re: using pg_fieldisnull
Previous Message Tom Lane 2000-07-12 23:08:23 Re: Re: [NOVICE] newbie problem on creating table