quick sql question

[Huscy]

CAn you combine these 2 queries into 1?
update table set points = $pts where clubname="$clubname" and position="gk"

and

update table set points = $pts where clubname="$clubname" and position="d1"

?

I know there is a mysql forum area, but i got zero reply there

[W1LL]

This should work!

[sql]UPDATE TABLE SET Points = $pts WHERE Clubname = "$clubname" AND (Position = "gk" OR Position = "d1")[/sql]

- Will

[biggulp]

UPDATE TABLE SET Points = $pts WHERE Clubname = '$clubname' AND Position IN ('gk', 'd1' )

[Huscy]

ah thanks

i didnt know you could use brackets like that - ta again