James Richie
19 lines
828 B
PHP
19 lines
828 B
PHP
<?php
|
|
|
|
$SQL = "create view view_supporttickets as
|
|
|
|
select supporttickets.*,
|
|
date_format(supportticket_created, '%c/%e/%Y %l:%i %p') as supportticket_created_verbose,
|
|
date_format(supportticket_changed, '%c/%e/%Y %l:%i %p') as supportticket_changed_verbose,
|
|
|
|
category.dropdown_value as supportticket_catagory_verbose,
|
|
status.dropdown_value as supoortticket_status_verbose
|
|
|
|
from supporttickets
|
|
|
|
join dropdowns category
|
|
on category.dropdown_serial = supporttickets.supportticket_category
|
|
|
|
left join dropdowns status
|
|
on status.dropdown_serial = supporttickets.supportticket_status";
|
|
?>
|