Re: Getting Newest
| From: | .: B i g D o g :. | Date: | Thu, 07 Nov 2002 13:36:43 +0000 |
| Subject: | Re: Getting Newest | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-123225@lists.php.net to get a copy of this message | ||
Why cant u do a query with some subselects and verify the date from each
one or do three queryies for the newest one and then compare them with
each other...
Should be relatively simple...
However, it would be better if the date where a timestamp...MHO
On Wed, 2002-11-06 at 21:10, Stephen wrote:
> I have three tables with certain content in each that's added almost daily. I want to get
> the most recent, out of those three tables, and then display it. How would I do that without
> changing the structure of my tables? (My current structure is this: id, date, name, text)
>
> Thanks,
> Stephen Craton
> http://www.melchior.us
>
> "Life is a gift from God. Wasting it is like destroying your favorite item you received
> from the person you love most." -- www.melchior.us
--
.: B i g D o g :.