In article <[EMAIL PROTECTED]>, 
[EMAIL PROTECTED] says...
> Can you d arithmetic division on two fields in an ORDER BY??
> 
> eg
> SELECT * FROM table_name ORDER BY field1 / field2 DESC
> 
> Can it be done?

Probably would work - give it a try :-) If you want to use the value you 
are ordering on, try 

ELECT * FROM table_name ORDER BY field1 / field2 AS something DESC

then you can retrieve the reuslt of the division as $something.

Cheers
-- 
David Robley
Temporary Kiwi!

Quod subigo farinam

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to