[RESOLVED] Divide in a SQL statement?

[wpearsall]

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

[ober0330]

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

[wpearsall]

how do u mean?...

i need to get data from my database:

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

[Electroman]

Does this not work?

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

[wpearsall]

OK,, LOL, how simple was that

thanks dood.