[Luis-]

Making a Kill Death Ratio mysql wise?

~ Regards, Luis.

[Snipa]

When you UPDATE, "%f", killsvar/deathsvar and put that integer in a new row.

[[L3th4l]]

pawn Код:

UPDATE .. Ratio = %f..", floatdiv(kills, deaths)

[Cyanide]

It's as simple as a regular mathematic question. I don't know why people are calling natives to divide when SQL has its own arithmetic division operator. Here's an example query:

pawn Код:

mysql_query( "UPDATE accounts SET Ratio = '%i / %i' WHERE name = '%s'", kills, deaths, name );

[Luis-]

If I am correct it would be a FLOAT on the mysql table?

[Luis-]

Alrighty, got it working. Thanks.