확장변수값 2개 비교

SELECT a.document_srl FROM (allmydreamcar.rx_document_extra_vars as a LEFT JOIN allmydreamcar.rx_document_extra_vars as b ON a.document_srl = b.document_srl) Where a.value=$args->user_phone and b.value=$args->car_number"

controller.php
$oDB = &DB::getInstance();

$query = $oDB->_query("SELECT a.document_srl FROM (allmydreamcar.rx_document_extra_vars as a LEFT JOIN allmydreamcar.rx_document_extra_vars as b ON a.document_srl = b.document_srl) Where a.value=$args->user_phone and b.value=$args->car_number");

$result = $oDB->_fetch($query);

Last updated