1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| function allCustomer($conn){
$sql="SELECT * FROM ServiceSubscriptions where (ServiceID=24 or ServiceID=25 or ServiceID=26 or ServiceID=30 or ServiceID=32
or ServiceID=44 or ServiceID=47 or ServiceID=48 or ServiceID=49 or ServiceID=50 or ServiceID=51 or ServiceID=54 or ServiceID=58
or ServiceID=60 or ServiceID=61 or ServiceID=63 or ServiceID=64 or ServiceID=65 or ServiceID=66 or ServiceID=67 or ServiceID=68 or ServiceID=69
or ServiceID=70 or ServiceID=71 or ServiceID=72 or ServiceID=73 or ServiceID=74) and Activated=1";
$resultat=odbc_exec($conn,$sql);
$liste=odbc_fetch_row($resultat);
$i=0;
while($liste){
$data[$i]=odbc_result($liste,2);
$liste=odbc_fetch_row($resultat);
$i++;
}
return $data;
} |