Hey, I am trying to build a search area for people to come in and search a database with two keywords. I am getting this error though: Parse error: syntax error, unexpected ';' in /home2/freedh/public_html/search.php on line 36 CODING: // This could be supplied by a user, for example // Formulate Query // This is the best way to perform a SQL query // For more examples, see mysql_real_escape_string() $query = sprintf("SELECT HUB, ARRIVAL, ETE, DISTANCE, MINIMUM_PAX, MAXIMUM_PAX, ROUTE, FLIGHT_# FROM routes WHERE HUB='%s' AND ARRIVAL='%s'", // Perform Query $result = mysql_query($query); // Check result // This shows the actual query sent to MySQL, and the error. Useful for debugging. if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } // Use result // Attempting to print $result won't allow access to information in the resource // One of the mysql result functions must be used // See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc. while ($row = mysql_fetch_assoc($result)) { echo $row['HUB']; echo $row['ARRIVAL']; echo $row['ETE']; echo $row['DISTANCE']; echo $row['MINIMUM_PAX']; echo $row['MAXIMUM_PAX']; echo $row['ROUTE']; echo $row['FLIGHT_#']; } // Free the resources associated with the result set // This is done automatically at the end of the script mysql_free_result($result); ?>