can't drop a table

[attaboy]

	$q = mysqli_query($mysqli, "DROP TABLE IF EXIST 'airline_survey'");
	if($q){echo "deleted the table airline_survey....<br>";}
	else{echo "damm... ".mysqli_error($mysqli);}

 

$mysqli is my connection and it works I had no trouble creating the table but I decided to add these few lines in front of the code to create the table and I get this error.

 

damm...You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXIST 'airline_survey'' at line 1

I gotta believe this is really simple but it's got me stumped.

[scootstah]

1. You need to use backticks, not apostrophes.

 

2. The keyword is "EXISTS" not "EXIST".

 

DROP TABLE IF EXISTS `airline_survey`

[attaboy]

Thanks!!!  I didn't know what a back tick was till now.