Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, March 29, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  I want to view latest records group by projects and Users.

phpMyEdit General     I want to view latest records group by projects and Users.
Post new topic   Reply to topic    
 
nkt     Joined: 16 May 2008   Posts: 14  
Post Posted: 2008-06-05 02:17
Back to top  Reply with quote     

I have follwing fields in table.

User, project, Testcases, Date , Test platform.

I want to view the latest records of all the projects on List page.

SQL that I use for mysql is as follows.

SELECT User,Projects,Test_Cases,MAX(Date) FROM table1 group by Projects,USER order by USER, Date DESC;

How do I get this on View page?

 
Post new topic   Reply to topic    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy