'scheduled',
'orderBy' => '`reader_ln_fn`',
'where' => "`title` = '$listY' && `school` = '$sch'",
'loadUploads' => false,
'allowSearch' => true,
));
// get reader name from scheduled; find in 'readers'; get email, phone and update scheduled
$rcnt = 0; $trcnt = 0;
foreach($scheduledRecords as $record){
$rdr = $record['reader']; // firstname lastname
$readr = trim($rdr);
var_dump($readr);
if($readr !== ""){
//$recno = $record['num']; // use when updating scheduled
// get reader email address, phone
$check = mysql_query("SELECT * FROM cms_readers WHERE full_name = '" . mysql_real_escape_string($readr) . "'") or die(mysql_error());
//var_dump(mysql_real_escape_string($readr));
$check2 = mysql_num_rows($check);
// if reader exists get email address
if($check2 > 0){
while($ifo = mysql_fetch_array( $check )){
$r_em = $ifo['email'];
$r_ph = $ifo['phone'];
$rcnt++;
}
}else{
$r_em = '';
$r_ph = '';
}
mysql_free_result($check);
// update reader info in scheduled
//mysql_query("UPDATE cms_scheduled SET reader_em = '".$r_em."', reader_phone = '".$r_ph."' WHERE num = '$recno'") or die(mysql_error());
}
$trcnt++;
}
echo '
Done!
Total Records: '.$trcnt.'
'.$rcnt.' records updated!';
?>