Advertisement
matthewpoer

AD Bid Scheduled Report query

Dec 17th, 2012
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.47 KB | None | 0 0
  1.         global $db;
  2.         $opps = array();
  3.         $query = "select id from opportunities
  4.        left join opportunities_cstm on id = id_c
  5.        where
  6.        bid_open_datetime_c > GETDATE()
  7.        and ( opportunities_cstm.package_received_c like 'on' or
  8.              opportunities_cstm.package_received_c = '1'  )
  9.        and opportunities.deleted=0
  10.        {$this->user_filter}
  11.        ORDER BY bid_open_datetime_c ASC ";
  12.         $results = $db->query($query);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement