In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Can you d arithmetic division on two fields in an ORDER BY??
> 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.
Quod subigo farinam
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php