Jump to content

firefox53074

New Members
  • Posts

    3
  • Joined

  • Last visited

firefox53074's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I'm not exactly sure what you mean by that? Those are just sample names that I chose for an example.
  2. Need report in PHP to pull a total number of items that are sent to the queues in a particular day and for orders that are completed from the queues in a single day. There is a list of ten different queues that I'm needing to gather this data from and pull into a csv file. I'm needing to use an array with if-then statement or case statements. I'm not sure what other information I'm going to need or where to start at. example of the statement IN_Queue[ ] foreach ($in_queue as $item) case match 1112 #test _cnt++; continue queue test select distinct item_number from queue_test WHERE search_type = '1112'; queue test 2 select distinct item_number from queue_test2 WHERE search_type = '1111'; So for the two examples above I am just pulling the distinct item_number but I'm needing a total count of items that was submitted and completed for those queues on a single day. I have a list of ten queues that I need that information from. So I will need to pull the total count of submitted and have it output into a csv file into a column called test submitted and the completed go to test completed for day.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.