On Saturday 27 July 2002 15:03, Georgie Casey wrote: > 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?
Try: SELECT *, (field1 / field2) AS doo FROM table_name ORDER BY doo DESC -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "I'm willing to sacrifice anything for this cause, even other people's lives." */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php