From: Yanek K. <ya...@ko...> - 2006-07-08 21:10:58
|
Started playing with phpwiki today. 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 phraseology should I be using? -Yanek. |