Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Selecting a mysql record's based on the month it was created.

Started by iamchristill, Nov 19 2011 01:41 PM

Please log in to reply

1 reply to this topic

#1
iamchristill

Posted 19 November 2011 - 01:41 PM

Newbie

Members
13 posts

Basicailly. The table is populated from a form on the front end and in the back end i need to show the total of the "Price" field based on month. Kinda like a profit and loss sheet.

The table has a datetime field and I need to know how to isolate the month and then display the records based on that.

Thanks

#2
WingedPanther

Posted 19 November 2011 - 02:24 PM

A spammer's worst nightmare

Moderators
16,831 posts

Location:Upstate, South Carolina
Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Why can't you select all the records "where date between '2011-08-01' and '2011-08-30'"?

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

Back to PHP Development