โดย thatsawan » 07/08/2014 5:57 pm
[code=php] $sql_ary = array(
'rate_name' => $name ,
'rate' => $rate ,
'rate_service' => $rate_service ,
'rate_price' => $normal,
'on_peak' => $onpeak,
'off_peak' => $offpeak ,
'pt_peak' => $ptpeak,
'type_id' => $type,
'user_id' => $user->data['user_id'] ,
'startuse_time' => strtotime($startuse_time),
'add_time' => time() ,
);
$sql = 'INSERT INTO ' . MOD_PRICE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
$sql_ary['rate_id'] = $db->sql_nextid();
//echo $sql; exit;
$sql = 'INSERT INTO ' . MOD_PRICE_HISTORY . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql); [/code]
[size=85][code=php] $sql_ary = array(
'rate_name' => $name ,
'rate' => $rate ,
'rate_service' => $rate_service ,
'rate_price' => $normal,
'on_peak' => $onpeak,
'off_peak' => $offpeak ,
'pt_peak' => $ptpeak,
'type_id' => $type,
'user_id' => $user->data['user_id'] ,
'startuse_time' => strtotime($startuse_time),
'add_time' => time() ,
);
$sql = 'INSERT INTO ' . MOD_PRICE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
$sql_ary['rate_id'] = $db->sql_nextid();
//echo $sql; exit;
$sql = 'INSERT INTO ' . MOD_PRICE_HISTORY . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql); [/code][/size]
:-D :-D