query problem

[boon_chong]

I'd like to query only the month of stockmovement.date, but when i use stockmovement.month(date) the error come out. Somebody please help me to figure out. thanks.

 

 

$query = "select distinct employee.itemNo,employee.itemDesc,employee.date,
employee.outlet,stockmovement.barcode,stockmovement.quantity,stockmovement.date 
from employee,stockmovement where 
employee.itemNo =stockmovement.barcode 
group by employee.itemNo";

[Greaser9780]

Without stockmovement.date this query still doesn't work does it?

 

[btherl]

If you group by itemNo, it implies there are multiple entries for each itemNo, and you want to group them together.  Then there is the question of how you group them together.  You can take the sum, the count, the average, or many other options.

 

What does the query do if you remove the group by?  Does it give extra rows that you don't want?

[boon_chong]

What i want is to get the month, instead of the whole date. Thx.

[roopurt18]

I responded to your other thread in the PHP Help area.

[fenway]

You can use MONTH() to get the month, or DATE_FORMAT() to get a pretty version of the month.