Re: [PHP] PHP querying mysql db for data limited to the last month

Sorry, I took that stuff out because it was making the page not load and so I figured it was wrong. I guess I should have posted the whole thing, but since it didn't work I left it out. Micah, thank you very much for the idea, it is working great!!! "Micah Gersten" <[EMAIL PROTECTED]> wrote i

Re: [PHP] PHP querying mysql db for data limited to the last month

Vinny Gullotta wrote: > So I have this code I'm working with (pasted below) that queries a > mysql db table called timetracking. The goal of the page is to search > the db for all data based on a certain engineer, sorted by product and > it takes pre-defined values based on actions performed, sums

Re: [PHP] PHP querying mysql db for data limited to the last month

1. To get last months date, you can use strtotime("1 month ago") instead of mktime. 2. I don't see anywhere in the code where you are limiting by date. Try using > and <. Between is tricky on dates. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gu

[PHP] PHP querying mysql db for data limited to the last month

So I have this code I'm working with (pasted below) that queries a mysql db table called timetracking. The goal of the page is to search the db for all data based on a certain engineer, sorted by product and it takes pre-defined values based on actions performed, sums them based on product and d