Re: Syntax Error

JD wrote:

Can anyone help me figure out what is wrong with this syntax. Thanks. list($qh,$num) = dbQuery("SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 ". "FROM $USER_TABLE WHERE username='$username'"); $data = dbResult($qh);

No need to repost your question. What is the $DATABASE_PASSWORD_FUNCTION variable ? What is the $USER_TABLE variable ? Since there are 4 variables in this query ($DATABASE_PASSWORD_FUNCTION, $password, $USER_TABLE, $username), we have no idea what's actually being run. The easiest way to work out what's wrong is to print the query out and run it manually. $query = "SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 FROM $USER_TABLE WHERE username='$username'"; echo wordwrap($query) . "<br/>\n"; list ($qh, $num) = dbQuery($query); .... Post us the real sql query that's being run through that and we might be able to help you. -- Postgresql & php tutorials http://www.designmagick.com/