Guest User

Untitled

a guest
May 22nd, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | None | 0 0
  1. $result1 = ($type == "open")? mysql_query ("
  2.             SELECT  i.id 'incID', i.DATE 'date', i.STATUS, i.VEHICLE_ID, i.NOTES 'notes', i.INCIDENT_TYPE_ID, i.MILEAGE, t.id, t.VALUE 'value', v.id 'vid', v.FLEET_NUM 'fleet'
  3.                 FROM incident i , incident_type t, vehicle v
  4.                 WHERE i.STATUS = '1'
  5.                 AND i.INCIDENT_TYPE_ID = t.id
  6.                 AND i.VEHICLE_ID = v.id
  7.                 ORDER BY fleet
  8.             ") :
  9.            
  10.             mysql_query("SELECT     i.id 'incID', i.DATE 'date', i.STATUS, i.VEHICLE_ID, i.NOTES 'notes', i.INCIDENT_TYPE_ID, i.MILEAGE, t.id, t.VALUE 'value', v.id 'vid', v.FLEET_NUM 'fleet'
  11.                             FROM incident i , incident_type t, vehicle v
  12.                             WHERE i.STATUS = '0'
  13.                             AND i.INCIDENT_TYPE_ID = t.id
  14.                             AND i.VEHICLE_ID = v.id
  15.                             ORDER BY fleet");
Add Comment
Please, Sign In to add comment