Hmmm well it still tells me the same thing when I take the quotes off. Is there some type of casting that I might have to do? I have read about the cast command, but don't understand how to use it. -----Original Message----- From: Cornelia Boenigk [mailto:poppcorn@xxxxxxxxxxxxxxxxxxx] Sent: Wednesday, April 17, 2002 4:19 PM To: pgsql-php@xxxxxxxxxxxxxx Subject: Re: [PHP] Hi Preston @$sql="INSERT INTO checking VALUES('$check_date', '$check_num', '$check_pay', '$check_amount', '$check_trans_type');"; Try your INSERT without '' around '$check_amount'. The quotes are only used for character-types but not for numeric data. Regards Conni ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
