[RESOLVED] Problem with query string

[Jon12345]

I have the following code:

$whereclause="(status='Completed')";
$whereclause=$whereclause & " AND " & "(accountable='Jon' OR creator='Jon')";
$query="SELECT * FROM tasks WHERE " & $whereclause " & "ORDER BY priority";

I think there is something wrong with it because I am getting this error:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING

Any ideas?

Thanks,

Jon

[laserlight]

What's with the "&"?

$query="SELECT * FROM tasks WHERE " . $whereclause  . "ORDER BY priority";

[Jon12345]

Doh! I'm so used to doing Visual Basic. Thanks!