PHP MySQL JOIN table error querying database?

[Phil M]

Why am I getting an error? My tables are correct.

$user_search = $_GET['usersearch'];

// Connect to the database
require_once('connectvars.php');
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

$query = "SELECT * FROM casesubmission AS cs JOIN casetransactions AS ct ON ct.filenumber = cs.filenumber WHERE filenumber = '$user_search'";
$result = mysqli_query($dbc, $query)
or die ('Error Querying Database.');

$row = mysqli_fetch_array($result);
Parse error: syntax error, unexpected T_EXIT in /home/rpsancom/public_html/view_case.php on line 99

Here is Lines 98 & 99
$result = mysqli_query($dbc, $query)
die ( mysqli_error($dbc) );

 

[oops]

It will be a lot easier to trace if you report the error with:

die ( mysqli_error($dbc) );