[RESOLVED] Divide in a SQL statement?

OK.. i need to do a division in an SQL statement...

not sure how but,,,

like

fields: link_rating/number of links needs to return a new field called "sumrating" and be ordered by this in decending order...

its been a long time since i did ne fing like this and i forgot how..
so ;)

Umm... why can't you just do the division right before you create the SQL statement? :rolleyes:

how do u mean?...

i need to get data from my database:

Code:

---

Select link_rating, number_of_links, (sumrating = link_rating/number_of_links)
from TABLE
Where number_of_links>0
ORDER BY sumrating DESC

---

Does this not work?

Code:

---

Select link_rating, number_of_links, (link_rating/number_of_links) AS sumrating
from TABLE
Where number_of_links>0
ORDER BY sumrating DESC

---

OK,, LOL, how simple was that :D

thanks dood.