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.
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 |