Can anyone see whats wrong with this syntax? I've consulted the wordpress codex page and the syntax seems to be correct..
$result = $wpdb->query($wpdb->prepare( "SELECT * FROM {$wpdb->prefix}users WHERE username = %s AND password = %s, array( $username, $password )"));
Thanks