When I try to connect to postresql with my php script below I got hhis eror: I can insert into the table from psql. Please help Thanks, ----------------------------------------------------------------------------------------------------------- Warning: pg_exec() query failed: ERROR: invention: permission denied in /home/pptun/public_html/invention.php on line 9 ----------------------------------------------------------------------------------------------------------- Here is my PHP script:
<?PHP $L_Invention = addslashes($Invention); $L_Inventor = addslashes($Inventor); $L_Year = addslashes($Year); //note: Nation is a code with integer value $L_Nation = addslashes($Nation); $conn = pg_connect("dbname=pptun port=5432"); $result = pg_exec($conn, "insert into invention values('$L_Invention','$L_Inventor','$L_Year',$L_Nation);"); //header("Location:http://is3.usfca.edu/~pptun/invention.html"); exit; ?> --------------------------------- Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!