RE: Math and mySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux