mysql : Insert ranking to a table based on conditions ... urggh!

[ninefoureight]

table = results
fields = name date performance position meeting date

I have the above table and fields within it. I want to update the table and insert a score (rank) to an appended field in the table depending on conditions.

For each unique meeting on the same date i want to insert a score in the appended field depending on performance then position if the same performance for each name. The best. Incrementing the score given by 1 as you descend down the rank.

I think this would be made into a stored procedure once my host supports such, in the short term i would run this manually periodically.

I've looked at various rank examples and think i have my head round these but cant get my head round adding in this next step of complexity. Would anyone be able to give me a helping hand and and do the heavy lifting.. i need to see the light at the end of the tunnell.! ;]

cheers in advance.

 

[ninefoureight]

Appending != insert. It's an update.

Probably shouldnt use the literal command when explaining my problems.. ;] Point noted. The field will exist when i run the sql im asking after so it will be an Update.

 

[ninefoureight]

Not an app but plan to query the database heavily via a website. A table for every meeting will be a bit unweildy i think .. as many meetings have only 1 record