It's extremely straight-forward..
$q = $dbh->prepare("SELECT x,y,z from b where c = ?");
$q->execute("foo");
while (($x, $y, $z) = $q->fetchrow())) {
#stuff
}
$q = $dbh->prepare("INSERT INTO a(x,y,z) values(?,?,?);
$q->execute($x,$y,$z);
Mike Haberman wrote:
>
> I too need more info on PL/pgSQL than the docs supply.
>
> Is it possible for people to mail me any examples of PL/pgSQL. I
> just need to see examples of the syntax of the various control
> sturctures, variable assignment, and the like.
>
> >From simple to very complex, send anything that might be helpful.
>
> thanks a ton
>
> mike haberman
> mikeh@ncsa.uiuc.edu
>
> >
> > On Sat, 22 May 1999, Andy Lewis wrote:
> >
> > How can we tell you more if we don't know what you know? It's
> > usually pretty safe to just go ahead and ask the question. You'll be
> > redirected if you've posted to the wrong place.
> >
> > // I'd just plain would like to know more about PL/pgSQL.
> > //
> > // Andy
> > //
> > // On Sat, 22 May 1999, Piotr Stelmaszyk wrote:
> > //
> > // > I'd like to get to know where should I post messages concerning
> > // > PL/pgSQL.
> > // >
> > // >
> > // > /--------------------------------------------------------/
> > // > /- Piotr Stelmaszyk |---- Student of Computer Science ---/
> > // > /------------------ | at Poznan University of Technology /
> > // > /----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
> > // > /----- mailto:kelman@alpha.net.pl -----------------------/
> > // > /--------------------------------------------------------/
> > // >
> > // >
> > // >
> > //
> > //
> > //
> >
> > --
> > Principal Member Technical Staff, beyond.com The world is watching America,
> > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
> > | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
> > L______________________________________________ and America is watching TV. __
> >
> >
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com
