Hi,
I need to put mysql results inside an array. how i can do that?
i want to save mobile numbers as an array. (eg. $recipientNumber = array( "number 1", "number 2", ..., "number n");
my code:
//get customers mobile number
$sSqlWrk = "Select BirthDate, mobile FROM patients WHERE DATE_FORMAT(BirthDate,'%m-%d') = '".CurrentBdate()."'";
$theres =$conn->Execute($sSqlWrk);
while (!$theres->EOF) {
$recipientNumber .= $theres->fields('mobile');
$theres->MoveNext();
}
$theres->Close();
above codes return: $recipientNumber = "number 1number 2number 3";
what's wrong?
Thank You
Mansour