Answers

• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  January 2018 Answer ✓

  Is this the $db->select() method? It isn't clear from your question I'm afraid.

  You'll need to use $db->query() to do that and build up your own query.

  It might help to know that this is what the select() method does.

  Allan
• vincmeister Posts: 136Questions: 36Answers: 4

  January 2018

  yes Allan, $db->select() method
  This is my working example

  include_once( "../php/DataTables.php" );
   
  $cities = $db
      ->select( 'inp_master_cities', ['id as value', 'city as label'], ['province_code' => $_REQUEST['values']['province']] )
      ->fetchAll();
   
  echo json_encode( [
      'options' => [
          'city' => $cities
      ]
  ] );
  

  and I want to duplicate and add new condition AND item_code = $item_code to this

  ->select(
   'v_item_pr_po',
   ['item_code as value', 'item_name as label'],
   ['pr_no' => $_REQUEST['values']['prnumber'] ) **AND here**
  

  please advise, thank you
• allan Posts: 63,516Questions: 1Answers: 10,472 Site admin

  January 2018

  Did you try using the $db->query() method? Can you show me the code you used?

  Allan
• vincmeister Posts: 136Questions: 36Answers: 4

  January 2018 edited January 2018 Answer ✓

  Hi Allan,

  I solved my problem by using this

  ->select( 'v_item_pr_po', ['item_code as value', 'item_name as label'], ['pr_no' => $_REQUEST['values']['prnumber'] , 'q_po' => '> 0' ] )
  

  thanks