Re: php insert problem

Hey, dan... are you getting these messages? It seems we have a consensus.
Do you still get an error?

On Wed, 22 May 2002, Chris Thompson wrote:

> Should it not be
>
> $result = pg_exec ($database, "INSERT into employees (emp_name, emp_email) VALUES ('$emp_name','$emp_email');");
>
> Cheers
>
> On Wed, 22 May 2002, dan radom wrote:
>
> > <snip>
> >
> > $database = pg_connect ("host=localhost dbname=rbak user=nobody") or die("database connection failed");
> > $result = pg_exec ($database, "INSERT into employees (emp_name, emp_email) VALUES ('$emp_name','$emp_email')";
> >
> > if (!$result) {
> > echo "query died\n";
> > exit;
> > }
> >
> > </snip>
> >
> > the above code produces a parse error. "parse error, unexpected ';' in blah.php on line X"
> >
> > line X is the $result = pg_exec ($database, "INSERT into employees (emp_name, emp_email) VALUES ('$emp_name','$emp_email')"; line. I've started at this long enough, and it's time for other eyes to look. any ideas? similar SELECT queries work just fine.
> >
> > dan
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> > --
> > Virus scanned by edNET.
> >
>
> --
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the sender. Any
> offers or quotation of service are subject to formal specification.
> Errors and omissions excepted. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of edNET or lightershade ltd. Finally, the
> recipient should check this email and any attachments for the presence of
> viruses. edNET and lightershade ltd accepts no liability for any damage
> caused by any virus transmitted by this email.
>
> --
> --
> Virus scanned by edNET.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

-Chadwick