eds0n Posted April 5, 2007 Share Posted April 5, 2007 Hi! I have a bunch of program information from the process table in a mysql db. The data stored is for instance, creation date, process name, userid (owner of processes ) etc. What I want to do is choose a specific process i.e. 'firefox.exe' from a specific user. Find the first date, get all the instances of this program for this day, and then do this in interval of 1 days... and print it. Any pointers? I've tried this by using creationdate<Date_Add(creationdate, Interval 1 day) for testing, did not work. And still, I want process information from within a specific day. For instance, if the process starts for the first time today at 02:00, I want to see the record within the day -> 24:00.. in that instance that would mean 22 hours forward. Does anyone know if this is possible directly in SQL (MySQL) or using PHP? I need this data to calcuate averages and standard deviation on various process parameters. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/45651-date-intervals/ Share on other sites More sharing options...
Wildbug Posted April 5, 2007 Share Posted April 5, 2007 Have you tried using the GROUP BY clause? Quote Link to comment https://forums.phpfreaks.com/topic/45651-date-intervals/#findComment-222177 Share on other sites More sharing options...
gluck Posted April 5, 2007 Share Posted April 5, 2007 Can you paste the DB record? Also attach how you want the output and I might generate what you want. Quote Link to comment https://forums.phpfreaks.com/topic/45651-date-intervals/#findComment-222256 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.