How many orders shipped to specific states?

[Guest]

Hi,

I am looking for a way to search for orders shipped to specific states or countries. Like if i wanted to find out how many orders i shipped to california this month or week, or year. Same with a country too. Any one have a way to do this or is there a contribution i may have over looked? Thanks.

[Guest]

SELECT orders_id FROM orders WHERE delivery_state = 'this' or 'that'

 

this could be the 2-letter state code for example

that could be the state name for example

 

Then fetch the array. That would list all orders. You could use a count statement for the results if you just wanted the number of orders but didn't need details.

 

There's no contribution that I know of but that's some very basic starter code.