20 lines
952 B
PHP
20 lines
952 B
PHP
<?php
|
|
|
|
$SQL = "create view view_recreational_licenses as
|
|
|
|
select fwc_recreational_licenses.*,
|
|
|
|
date_format(fwc_recreational_licenses.license_start_date, '%c/%e/%Y') as license_start_date_verbose,
|
|
date_format(fwc_recreational_licenses.license_expire_date, '%c/%e/%Y') as license_expire_date_verbose,
|
|
|
|
counties.dropdown_serial as license_counties_serial,
|
|
licensetypes.dropdown_serial as license_type_serial
|
|
|
|
from fwc_recreational_licenses
|
|
|
|
join dropdowns as counties
|
|
on counties.dropdown_value = fwc_recreational_licenses.license_county
|
|
|
|
join dropdowns as licensetypes
|
|
on licensetypes.dropdown_value = fwc_recreational_licenses.license_type";
|
|
?>
|