Help With Select Query

[golfinggod]

Hi can someone convert my query so that it produces a message stating

Nothing Exists

if the the query below can not find the variable $flightn in the database.

Thanks All🙂

/// Check By Flight Number ///

if($_POST['Flightn'] != '')
	{
	$flightn = $_POST['Flightn'];
	// Check To See If Flight Number Exists //
	$result = mysql_query("SELECT * FROM flightroute WHERE FlightNo = $flightn ") or die(mysql_error();

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {}

}

[laserlight]

/// Check By Flight Number ///
if (!empty($_POST['Flightn']))
{
	$flightn = $_POST['Flightn']; //validate/cast data here
	// Check To See If Flight Number Exists //
	$result = mysql_query("SELECT * FROM flightroute WHERE FlightNo='$flightn'")
		OR die(mysql_error();

if (mysql_num_rows($result) > 0) {
	while ($row = mysql_fetch_array($result, MYSQL_NUM))
	{
		//...
	}
}
else
{
	echo "Nothing Exists";
}
//...
}