[RESOLVED] Multiple Updates

[Anyaer]

I'm sure there's a way to do this, but I can't seem to find the syntax MySQL wants from me. I'm trying to do some multiple updates. $_POST passes in 3 variables: yahoo, msn, google which each have a value. Then I need to update a table that just has the search engine names and an associated value.

I tried

UPDATE <table> SET <value column>=$_POST[google] WHERE search_engine='google' AND SET <value column>=$_POST[yahoo] WHERE search_engine='yahoo'

but no dice.

[leatherback]

In general you should do this in separate queries.

I am not sure whether mysql 5 allows multiple updates in one query.

[Anyaer]

Got it and done.