whats wrong with this query?

[jwk811]

[code]    $sql = "UPDATE selling
            SET allow = '$allow', message = '$message', note = '$note' AND
        SET method = '$method0', amount = '$amount0', price = '$price0' WHERE row_id = '1'
    AND SET method = '$method1', amount = '$amount1', price = '$price1' WHERE row_id = '2'
            AND SET method = '$method2', amount = '$amount2', price = '$price2' WHERE row_id = '3'
            AND SET method = '$method3', amount = '$amount3', price = '$price3' WHERE row_id = '4'
            AND SET method = '$method4', amount = '$amount4', price = '$price4' WHERE row_id = '5'
    AND SET method = '$method5', amount = '$amount5', price = '$price5' WHERE row_id = '6'
            AND SET method = '$method6', amount = '$amount6', price = '$price6' WHERE row_id = '7'
            AND SET method = '$method7', amount = '$amount7', price = '$price7' WHERE row_id = '8'
            AND SET method = '$method8', amount = '$amount8', price = '$price8' WHERE row_id = '9'
            AND SET method = '$method9', amount = '$amount9', price = '$price9' WHERE row_id = '10'";[/code]

[btherl]

You can only have one WHERE clause in a query.  Break it up into seperate queries and you'll be fine :)