Re: Odd "INSERT" Problems with PostgreSQL - Do YOU know? - Mailing list pgsql-general

From Diana Cionoiu
Subject Re: Odd "INSERT" Problems with PostgreSQL - Do YOU know?
Date
Msg-id Pine.LNX.4.30.0105240602410.5796-100000@tudor.softwaresolutions.ro
Whole thread Raw
In response to Odd "INSERT" Problems with PostgreSQL - Do YOU know?  ("Jason" <jason@op480.com>)
List pgsql-general
>Here's my sql statement:
>$sql = "insert into pricing (prod_id, size_id, price) values ($prod_id,
>$size_id, 0.00)";
>
>here's an example of what it generates before it inserts:
>insert into pricing (prod_id, size_id, price) values (148, 48, 0.00)

The problem is from php, please do this
print $prod_id;
and see what it give you
in php you must have someting like.
$mumu = pg_exec ($conn, "insert into mumulica (mumu1,mumu2) values('" .
$mumu1 . "','" . $mumu2 . "')");

>Thanks!

Have fun

Diana


pgsql-general by date:

Previous
From: "Jason"
Date:
Subject: Odd "INSERT" Problems with PostgreSQL - Do YOU know?
Next
From: "Richard Huxton"
Date:
Subject: Re: Odd "INSERT" Problems with PostgreSQL - Do YOU know?