Re: Math and mySQL

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

 



select MAX(id), * from tablename

you can also use a datetime field to select from as well, depends on your data structure

bastien

From: "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx>
To: "Bastien Koert" <bastien_k@xxxxxxxxxxx>, <php-db@xxxxxxxxxxxxx>
Subject: Re:  Math and mySQL
Date: Fri, 31 Dec 2004 20:53:10 -0500

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


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

  Powered by Linux