I am currently experiencing a problem passing data from a PHP page to
PostgreSQL. 

 I am passing different data types like numeric, and text.  Let me show you
some of the code I am using....

This is the code that I am using to pass the input data to a page called
"checkbook2.php"


  
Check Date
    
    Check Number
    
    Check Payee
    
    Check Amount
    
  
  
Check Transaction Type
    
  
  
  

This is the data from the checkbook2.php that talks to the PostgreSQL
Server.  It is running version 7.2.

$conn=pg_connect("host=192.168.0.2 user=postgres password=postgres
dbname=checkbook");

@$sql="INSERT INTO checking VALUES('$check_date', '$check_num',
'$check_pay', '$check_amount', '$check_trans_type');";

$result=pg_exec($conn, $sql);

check_data is type text
check_num is type int4
check_pay is type text
check_amount is type numeric(8,2)
check_trans_type is type text

The error that comes up is ...
Warning: PostgreSQL query failed: ERROR: Bad numeric input format
'check_trans_type' in /etc/httpd/htdocs/checkbook2.php on line 41

Anyone know what could be going on here??  Please let me know, thanks in
advance! :)