ticker.php

<?php

require_once 'inc/standard.php';

foreach ($_GET as $key => $value) {
	//echo '$user[\''.$key.'\'] = '.$value.';<br>';
	$scan[$key] = trim(strip_tags($value));
}

$limit = ($_GET['view'] == 'all') ? '':'LIMIT 5';

if($scan['eid'])
{
    $sql = 'SELECT barcodes.barcode, scans.*, users.name, users.ucinetid, users.major, users.level
    		FROM scans 
    		LEFT JOIN barcodes
    		    LEFT JOIN users
    		    ON barcodes.ucinetid = users.ucinetid
    		ON barcodes.barcode = scans.barcode
    		WHERE scans.eid = "'.$scan['eid'].'"
    		ORDER BY scans.date DESC, scans.time DESC
    		'.$limit;
	$DB->query($sql);
    $output['scans'] = $DB->resultToArray();
}
else
{
   $output['message']['text'] = "No Event Id Provided";
   $output['message']['status'] = "error";
}
$DB->close();

echo json_encode($output);
?>