Error Code " .mysqli_connect_errno() . ": " . mysqli_connect_error()) . "
"; $DBName = "skyward_aviation"; @mysqli_select_db($DBConnect, $DBName) Or die("Unable to select the database.
" . "Error Code " . mysqli_errno($DBConnect) . ": " . mysqli_error($DBConnect)) . "
"; $TableName = "frequent_flyers"; $SQLstring = "SELECT * FROM $TableName WHERE flyerID='$FlyerID'"; $QueryResult = @mysqli_query ($DBConnect, $SQLstring) Or die ( "Unable to exequte Select query.
" . "Error Code " . mysqli_errno($DBConnect) . ": " .mysqli_error($DBConnect)). "
"; if (mysqli_num_rows($QueryResult) == 0) exit("Invalid frequent flyer number!
"); $Row = mysqli_fetch_row($QueryResult); $CustomerName = $Row[3] . " " .$Row[4]; $TableName = "mileage"; $Mileage =0; $SQLstring= "SELECT SUM(mileage) FROM $TableName WHERE flyerID = '$FlyerID'"; $QueryResult = @mysqli_query($DBConnect, $SQLstring); if (mysqli_num_rows ($QueryResult) > 0) { $Row = mysqli_fetch_row($QueryResult); $Mileage = number_format($Row[0],0); mysqli_free_result($QueryResult); } mysqli_close($DBConnect); ?>|
CustomerName: Frequent Flyer #: Mileasge Credit: |
|