Citat:
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:
Kod:
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:
Kod:
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....