|
| 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/
|
|