Sorry for being to vague last time I asked this question. 

I have this existing table in my database the shows the prizes for certain events. I am looking to run a query in phpMyAdmin to correctly make the existing prizes be multiplied by 50, divided by 2 then rounded up to the nearest whole number.

For example rank 1 in event\_id 1 would be (120\*50)/2 shown as new\_prize.

an example of my table is as follows:

```
event_id   ranking     prize
1          1           120
1          2           60
2          1           10
2          2           5

```

I hope I have better explained it this time. Thank you for any help provided.