[Conny Westh]

Ursprungligen postat av frecka

Varför blir detta fel? Får man inte göra LIMIT på UPDATE?
UPDATE teams_players SET level = 1 WHERE level = 0 AND team_id = {$team_id} ORDER BY joined ASC LIMIT 1

{$team_id} är en siffra

Du borde använda en subselect för att det ska funka bra:

UPDATE teams_players SET level = 1 
WHERE level = 0 
AND team_id = {$team_id} 
AND  joined = (Select joined FROM teams_players ORDER BY joined ASC LIMIT 1)

Vet inte riktigt vad vill ha men det kan även vara så här:

UPDATE teams_players SET level = 1 
WHERE level = 0 
AND team_id = {$team_id} 
AND  joined = 
(
    Select joined 
    FROM teams_players
    WHERE level = 0 
    AND team_id = {$team_id} 
    ORDER BY joined ASC LIMIT 1
)

Eller nåt i den stilen....