Re: Pear Auth and SQL

Simon H wrote:

Can anyone explain to me why this wont work, or if there is another way to use the (logged on) users Username in a query: $UserDetailsSQL = 'SELECT * FROM users WHERE UserID = $a->getUsername()';

$UserDetailsSQL = "SELECT * FROM users    WHERE  UserID = '$a->getUserName()'";

when you have a variabable inside a single quote the variable is not evaluated. Eg: $s = '$x' and $s="$x" are different. The first one will print $x while the other one will print the value of $x. example: $x=2; $s="$x"; echo $s; will output 2 $x=2; $s='$x'; echo $s; will output $x. kancha.