From: Yanek K. <ya...@ko...> - 2006-07-10 01:34:17
|
Started playing with phpwiki this weekend. For the most part, things have gone smoothly... however I can't seem to make PostgreSQL authentication work. The "select if" syntax is invalid in postgres, so I tried this: DBAUTH_AUTH_CHECK = "SELECT userid AS ok FROM users WHERE userid='$userid' and passwd='$password'"; However, that always returns "Invalid password." How can I troubleshoot this? What kind of SQL phraseology should I be using? -Yanek. |