1 2 3 4 5 6 7 8 9 10 11
| $sql="select * from short_numbers where id_short_numbers NOT IN(select * from type_msg_recus where ref_type_msg='".$_POST['ref_type_msg']."')";
//$sql="select * from short_numbers where id_short_numbers='".$_POST['numeros_appel']."'";
$res=mysql_query($sql);
$data=mysql_fetch_array($res);
$smsc=$data['smsc'];
$numero=$data['numero'];
$sql="select * from type_msg_recus where ref_type_msg='".$_POST['ref_type_msg']."'";
$res=mysql_query($sql);
$data=mysql_fetch_array($res);
$sql="insert into type_msg_recus(type_msg,numeros_appel,smsc,categorie_msg,id_categorie_service,statut,text_info,avec_code,synonyme_de) values('".addslashes($_POST['synonyme'])."','".$numero."','".$data['smsc']."','".$data['categorie_msg']."','".$data['id_categorie_service']."','".$data['statut']."','".addslashes($data['text_info'])."','".$data['avec_code']."','".addslashes($data['type_msg'])."')";
mysql_query($sql); |
Partager