Hi Michael,
Using two select's we already solved the problem. The challenge is to make
the same thing using just one select. I need to know if is there an way to
get the last date or the 10th index to make the WHERE part. Like the
LAST_INDEX() function, that gets the last AUTO_INCREMENT...but I
Well, could you explain the behave of ORDER BY DATE,COD?
I will show you bellow what I want, graphically:
>1) What I have:
>
>Table: processo_arquivos
>
>_
>|Cod| Date |
>-
>|1 | 12/10 |
>-
>|2
: SQL Select Idea
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS
wrote:
>Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT
query
worked, as posted by someone else, w
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote:
>Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT query
worked, as posted by someone else, which you quoted. What do you
what I'm doing above using only ONE select.
Any tips?
Best Regards,
Felipe
-Mensagem original-
De: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Enviada em: quarta-feira, 4 de dezembro de 2002 02:06
Para: [EMAIL PROTECTED]
Assunto: Re: RES: SQL Select Idea
On Tue, Dec 03, 2002 at
zembro de 2002 01:03
Para: Felipe Moreno - MAILING LISTS
Assunto: Re: RES: SQL Select Idea
Felipe -
Maybe you could...
(1) Put the first result set into a temp table, on which you could execute
subsequent queries, or
(2) Use php to construct an array of the result rows, and then use php's
arra
On Tue, Dec 03, 2002 at 07:02:02PM -0200, Felipe Moreno - MAILING LISTS wrote:
> 2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE
> DESC LIMIT 0,3 (considering that I only want 3)
[ that worked as described ]
> 3) The problem getting the result like this:
>
> Since I have
Hi Jim and others that tried to help me!
Thanks for any kind os answer.
Well, the SQL command that you suggested don't work for me. Below, I will
show What I want and what I get if I use the select command you suggested:
1) What I have:
Table: processo_arquivos
_
|Co
