Advertisement
davidjmorin

Empty Results from Date invoice

Oct 17th, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.33 KB | None | 0 0
  1. if(!empty($_POST['sdate'])){
  2.  
  3. $query    = "SELECT l.AddressCode,
  4.            l.owner,
  5.            l.City,
  6.            l.State,
  7.            l.Zip,
  8.            i.RefNumber,
  9.            i.memo,
  10.            i.Txndate,
  11.            i.DueDate,
  12.            i.ItemCustomerFullName,
  13.            i.PO_number ,
  14.            i.ItemAmount,
  15.            i.PO_number,
  16.            i.preorder_,
  17.            i.Quantity,
  18.            i.Vendor,
  19.            i.balance
  20.            FROM imw_locations l
  21.            INNER JOIN vzw_invoice i
  22.            ON l.AddressCode=i.ItemCustomerFullName
  23.            WHERE l.owner='" . $owner . " '
  24.             AND Txndate BETWEEN '".$sdate."' AND '".$edate."'
  25.            
  26.     ";
  27.    
  28. }
  29.  
  30. if(empty($_POST['sdate'])){
  31.      $query    = "SELECT l.AddressCode,
  32.            l.owner,
  33.            l.City,
  34.            l.State,
  35.            l.Zip,
  36.            i.RefNumber,
  37.            i.memo,
  38.            i.Txndate,
  39.            i.DueDate,
  40.            i.ItemCustomerFullName,
  41.            i.PO_number ,
  42.            i.ItemAmount,
  43.            i.PO_number,
  44.            i.preorder_,
  45.            i.Quantity,
  46.            i.Vendor,
  47.            i.balance
  48.            FROM imw_locations l
  49.            INNER JOIN vzw_invoice i
  50.            ON l.AddressCode=i.ItemCustomerFullName
  51.            WHERE l.owner='" . $owner . " '
  52.            
  53.            
  54.     ";
  55. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement