Hello All,
I keep receiving the following when trying to select from a table in my database. the Tables are there i see them in pgAdmin...
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: relation "userroles" does not exist
The query I'm running is
SELECT userPassword, salt, roleName
FROM User u, UserRoles ur, Roles r
where u.id = ur.user_id
and r.id = ur.role_id
and u.username = $1
and u.active = true
I keep receiving the following when trying to select from a table in my database. the Tables are there i see them in pgAdmin...
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: relation "userroles" does not exist
The query I'm running is
SELECT userPassword, salt, roleName
FROM User u, UserRoles ur, Roles r
where u.id = ur.user_id
and r.id = ur.role_id
and u.username = $1
and u.active = true
