thanks, im not aware that php also has max(), ty. On Thu, 18 Nov 2004 23:46:01 -0700, Dennis Seavers <deseavers@xxxxxxxxxxxxxx> wrote: > 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 > > -- Louie Miranda http://www.axishift.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php