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
