$sql = "select status,curdate(),max_emails,last60_flag,aol_flag,open_flag,yahoo_flag,hour(schedule_time),minute(schedule_time),mid,redirect_domain,campaign_nam +e from campaign where campaign_id=$campaign_id"; 

$sth = $dbh->prepare($sql); $sth->execute(); 

($status,$schedule_date,$max_emails,$clast60,$aolflag,$openflag,$yahoo_flag,$sho +ur,$smin,$old_mid,$old_dname,$cname) = $sth->fetchrow_array();