Bob Bedford schreef:
>> set @id:=0;
>> UNDATE yourfile set id=@id:=@id+1 ORDER BY yourdate
>
> You are a king Luuk !!!!
>
> I spent 3 hours without being able to do it and you did it in 2 lines of
> Mysql !!!!
>
> Thanks a lot !!!!!!
>
>

somone in this group provided the example some days, (or weeks?) ago ;-)


--
Luuk