jwk811 Posted November 27, 2006 Share Posted November 27, 2006 [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] Quote Link to comment Share on other sites More sharing options...
btherl Posted November 27, 2006 Share Posted November 27, 2006 You can only have one WHERE clause in a query. Break it up into seperate queries and you'll be fine :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.