Hi Michael, The ten last dates appear as a default result of a Archives page. When I enter for the first time in the page, it give me the last ten Files that was uploaded. In the same page, I can ORDER BY the ten last dates results by COD, DATE, NAME or FILE. So, when I click in some os then, I need to ORDER the TEN DATES, not the entire table and give ten results, did you get it?
Any idea? Regards, Felipe -----Mensagem original----- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de dezembro de 2002 17:33 Para: [EMAIL PROTECTED] Assunto: Re: RES: RES: 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, which you quoted. What do you then intend to do with that data? > > Since I have a link in the header of the tabel that make the ORDER BY work, > > when I select de COD after the result above, I should get: > > [ you didn't give the EXACT SQL QUERY that you're typing in; please give > it ] Again, you didn't quote the "when I select the COD after ..." <-- what is that query? And how do you expect it to behave. > I'm assuming that you're forgetting a step, or misunderstanding a step > involved. Are you doing anything with that data you're selecting, or just > selecting it and leaving it? You might be wanting to select it into a new > table or something; look up "INSERT INTO ... SELECT FROM ...". This still applies. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
