Try using the SQL aggregate function MAX() or the PHP function max() > [Original Message] > From: Louie Miranda <lmiranda@xxxxxxxxx> > To: <php-general@xxxxxxxxxxxxx> > Date: 11/18/2004 11:34:57 PM > Subject: getting the highest number in 3 db fields? > > I have a db field of 3. > > - prolog > - transmodal > - asian > > I wish to get the highest number of those three, in different fields. > > Im thingking of.. > > if (row0 =< row1) ... > > how about row2? > > confused.. > > -- > Louie Miranda > http://www.axishift.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
