25 lines
1.5 KiB
PHP
25 lines
1.5 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
$SQL = "create view view_commercial_licenses as
|
||
|
|
|
||
|
|
select commercial_license_serial, commercial_license_code, commercial_license_number, commercial_license_applicant_id,
|
||
|
|
commercial_license_florida_residency, commercial_license_issued_to, commercial_license_scope,
|
||
|
|
commercial_license_begin_date, commercial_license_expire_date, commercial_license_company_or_last_name,
|
||
|
|
commercial_license_county, commercial_license_endorsement_expiration_date,
|
||
|
|
commercial_license_endorsement_number, commercial_license_total_tag_qty,
|
||
|
|
|
||
|
|
date_format(commercial_license_begin_date, '%c/%e/%Y') as commercial_license_begin_date_verbose,
|
||
|
|
date_format(commercial_license_expire_date, '%c/%e/%Y') as commercial_license_expire_date_verbose,
|
||
|
|
|
||
|
|
counties.dropdown_serial as commercial_license_counties_serial,
|
||
|
|
licensecodes.license_serial as commercial_license_type_serial,
|
||
|
|
licensecodes.license_description as commercial_license_type_code_verbose
|
||
|
|
|
||
|
|
from fwc_commercial_licenses
|
||
|
|
|
||
|
|
join dropdowns as counties
|
||
|
|
on counties.dropdown_value = fwc_commercial_licenses.commercial_license_county
|
||
|
|
|
||
|
|
join fwc_commercial_license_codes as licensecodes
|
||
|
|
on licensecodes.license_code = fwc_commercial_licenses.commercial_license_code";
|
||
|
|
?>
|