Hi.
This is my first post here, so I apologise if I breaking any codes of conduct 🙂
I'm having a problem connecting my PHP pages to my PostgreSQL database. I'm trying to read one row from a table called profiles. The query I'm using works fine from the shell window, but spits out an error when I try it from the PHp page. Any help would be appreciated, although I realise this is a simple problem that only a n00b would have. The error message I get is this: Warning: PostgreSQL query failed: ERROR: profiles: Permission denied. in logintest.php on line 15. Line 15 is the actual query line, and the line reads: $result = pg_exec($dbconn,"SELECT * FROM PROFILES WHERE UName='$username';");. The connection seems to work now, and $username is passed from a form on the previous page, and seems to get through OK. Hope someone can help.
Cheers,
PuzzledStudent
