wilded
8/7/2017 - 9:09 AM

Getting Several Values With Array on SQL Query (SelectSqlItem)

Getting Several Values With Array on SQL Query (SelectSqlItem)

$sqlGetCardPin_ActDate = "SELECT CONCAT_WS('-', poiCarSecurityCode, poiCarActivationDate) FROM  tblPointCards WHERE poiCarNumber = '$syychaPoiCarNumber'";
$GetCardPin_ActDate = $dgrid->SelectSqlItem($sqlGetCardPin_ActDate);
$GetCardPin_ActDate_array = explode('-', $GetCardPin_ActDate);
$GetCardPin = $GetCardPin_ActDate_array[0];
$GetActDate = $GetCardPin_ActDate_array[1];
if(!$GetCardPin_ActDate_array){
  echo "<script>alert('$alertCartActivateCard $syychaPoiCarNumber')</script>";
}