phpnewbie1989

IM again sorry to bother, I have not had much luck at following those steps. It tells me there was an unexpected ='s where I put the SQL=  line.

Thank you very much for the Help. I really appreciate this.

Okay lets see if I can do this :) I am trying to build the form, but in the coding I dont know how to specify that the two fields in the form are my search keywords for the SQL database data. How do I designate the two form fields as my search criteria?

Thank you for the tip I really appreciate it. I just have one more question and I promise I wont ask anymore stupid things. How can I get a form to work with the php. I need to make it so that the people can insert the actual query words or keywords. I would really appreciate this last bit of help.

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); ?>

This may be easy or not, but im wondering to how to make a search engine that will find results for one keyword and another keyword in PHP. I want a person to be able to enter a webpage and fill out a form that asks for a keyword and a second keyword, then it will search a SQL database and come up with the results. How would I program this?