Re: novice, question

Hey,

What you might have to do is
$total_rows = pg_numrows($result);

do {
pg_fetch_object($result,$i);
$i++;
} while ($i < $total_rows);

>Andy Arledge wrote:
> >
> > anyone have an idea why this won't work? when i print out "i" it says 893,
> > but it should be 41. and the values are null for the array $userinfo.
> >
> > thanks in advance,
> >
> > andy arledge
> >
> > if(!($result= pg_exec($link, "SELECT * from signup, info1, info2 where
> > (signup.username='$uname' or
> > info1.username='$uname' or
> > info2.username='$uname');"))){
> > DisplayErrMsg(sprintf("Error in executing line %s stmt",
> > $selectStmt));
> > exit();
> > }
> > for($i = 0; $userinfo = @pg_fetch_object($result, $i); $i++);
>
>Why is there an '@' in front of that pg_fetch_object call?

So it doesn't print an error when there are no results left.

------------------------
Chris Smith
http://www.squiz.net