10 lines
294 B
PHP
10 lines
294 B
PHP
|
<?php
|
||
|
|
|
||
|
|
$SQL = "create view view_cities as
|
||
|
|
|
||
|
|
select cities.*,
|
||
|
|
date_format(city_created, '%c/%e/%Y %l:%i %p') as city_created_verbose,
|
||
|
|
date_format(city_changed, '%c/%e/%Y %l:%i %p') as city_changed_verbose
|
||
|
|
|
||
|
|
from cities ";
|
||
|
|
?>
|