php - Querying a wordpress database -

can see whats wrong syntax? i've consulted wordpress codex page , syntax seems correct..

$result = $wpdb->query($wpdb->prepare( "select * {$wpdb->prefix}users username = %s , password = %s, array( $username, $password )")); 

thanks

try:

 $result = $wpdb->query($wpdb->prepare( "select *     {$wpdb->prefix}users username = %s , password = %s", array( $username, $password ))); 

your quotes incorrect.