On Apr 28, 2007, at 10:09 AM, Richard Dunne wrote:
> $result=pg_query($connect, "insert into customer values
> ('$customer_name', '$customer_address', '$customer_contact_no')");
Are these really the first columns in the customer table? If not, you
need to specify the target columns in the insert, e.g.
insert into customer (customer_name, customer_address,
customer_contact_no) values ('$customer_name', '$customer_address',
'$customer_contact_no')
Even if these are the first columns, it is not a good idea to leave
the column specs out since your code will break if you change the
table in an incompatible way.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL