prepare('select a.email_addr, a.firm, a.contact_name, a.addr1, a.addr2, a.city, a.state, a.zip, a.country, a.phone, a.fax, a.mbe, a.wbe, a.verified, a.gc, a.sdve from (select email_addr, max(downloadtime) as latest_time from download_info where projectnum = :projectnum group by email_addr) as x inner join download_info as a on a.email_addr = x.email_addr and a.downloadtime = x.latest_time');
$distinct_firm_stmt->bindParam(':projectnum', $prj, PDO::PARAM_STR, 12);
$distinct_firm_stmt->execute();
$result = $distinct_firm_stmt->fetchAll();
}catch (PDOException $e){
echo $e->getMessage();
}
foreach ($result as $row){
$firm = $row['firm'];
$email = $row['email_addr'];
?>
|
' . $row['addr1'] . ' '; if($row['addr2'] != "") {echo $row['addr2'] . ' ';} echo $row['city'] . ', ' . $row[state] . ' ' . $row['zip'] . '' ; ?> |
prepare('select filename, downloaddate from download_info where projectnum = :projectnum and email_addr = :email_addr');
$firm_docs_stmt->bindParam(':projectnum', $prj, PDO::PARAM_STR, 12);
$firm_docs_stmt->bindParam(':email_addr', $email, PDO::PARAM_STR, 12);
$firm_docs_stmt->execute();
$docs_result = $firm_docs_stmt->fetchAll();
}catch (PDOException $e){
echo $e->Message();
}
foreach ($docs_result as $docs_row){
$filename = $docs_row['filename'];
$downloaddate = $docs_row['downloaddate'];
}
echo 'Phone: ' . $row['phone'] .' '; echo 'Fax: ' . $row['fax'] .' '; echo '' . $row['email_addr'] . ''; //if($gc_check1 != '1'){ if ( $prj == 'cp110341' || $prj == 'cp091391'){ echo ' '; } else{ echo ' GC: ' . $row['gc'] . ' '; } echo 'MBE: ' . $row['mbe'] . ' WBE: ' . $row['wbe'] . ' SDVE: ' . $row['sdve']; ?> |
Plan Holder List
Information displayed on this page has been submitted via a web form and has not been verified by University of Missouri.
If you would like to have your information verified or suspect fraudulent activity, please contact the Document Center at umccfpdcdoccenter@missouri.edu.