Posted by Captain Paralytic on 08/02/07 10:18

On 2 Aug, 08:55, newbie <mitbb...@yahoo.com> wrote:
> table 'order' looks like this:
>
> ------------------------------------------------------------
> | order_id (int) | time_placed(datetime) |
> ------------------------------------------------------------
> | 014 | 2007-07-12 12:12:00 |
> ------------------------------------------------------------
>
> I want to query all the orders that are placed on a particular
> month( and different month has different ending date--28, 30, 31). I
> want to have a sort of function with the following interface, is there
> an existing mysql function does that?
> Thanks.
>
> function select_order_of_month($month) {
> $sql_query = "SELECT COUNT(*) FROM `order` WHERE *I really want to
> specify the interval for the whole month here*";
>
>
>
> }- Hide quoted text -
>
> - Show quoted text -

I would suggest asking MySQL questions in
comp.database.mysql
(the name give you a hint "comp.lang.php" for questions on php
"comp.database.mysql" for questions on MySQL - geddit!)

• Next in forum: Re: [offtopic:Netiquette} How about const supporting array in future?
• Prev in forum: Re: Text field as date (MySQL)
• Thread view: Re: comparing datetime() in database

[Reply to this message]