Do you have the actual syntax for the SELECT command to retreive the last record? Ron ----- Original Message ----- From: Bastien Koert <bastien_k@xxxxxxxxxxx> To: <ron.php@xxxxxxxxxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx> Sent: Thursday, December 30, 2004 10:53 AM Subject: RE: Math and mySQL > see intersperesed comments > > bastien > > >From: "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx> > >To: "PHP DB" <php-db@xxxxxxxxxxxxx> > >Subject: Math and mySQL > >Date: Thu, 30 Dec 2004 05:51:44 -0500 > > > >Is there any way of retreiving the last record of a mySQL table where I may > >specify one of the values in it? I know the SELECT command and just for > >example the field I know could be serial_number = 30612312-ABDEFG --- I > >have > >the serial_number field set as a varchar. > > > > yes, you can do a select on the table to get that record > > > >Part two of my question is how do you do math in PHP? I want to take the > >running_total (another field in the table) and add or subtract what the > >user > >has typed in. > > > > assign the value to a variable and simply add/substract/etc between the two > values > > > >Ron > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
