Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $result1 = ($type == "open")? 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'
- FROM incident i , incident_type t, vehicle v
- WHERE i.STATUS = '1'
- AND i.INCIDENT_TYPE_ID = t.id
- AND i.VEHICLE_ID = v.id
- ORDER BY fleet
- ") :
- 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'
- FROM incident i , incident_type t, vehicle v
- WHERE i.STATUS = '0'
- AND i.INCIDENT_TYPE_ID = t.id
- AND i.VEHICLE_ID = v.id
- ORDER BY fleet");
Add Comment
Please, Sign In to add comment