snowfire

Nevermind, I figured it out. stuck a semicolon at end of query. stupid mistake.

this page is supposed to query the database using variables supplied in a form. however, I cannot get the query to work right. I keep getting this error and i don\'t understand what it means. this is the code that\'s causing it <?php $Author = $_POST[\'Author\']; $Title = $_POST[\'Title\']; $Topic = $_POST[\'Topic\']; $min_year = $_POST[\'min_year\']; $max_year = $_POST[\'max_year\']; $advisor = $_POST[\'advisor\']; $Link = mysql_connect("computer", "username", "password"); $query_database_search = "SELECT Title, Firstname, Middlename, Lastname, TR_Id FROM Students WHERE Lastname = \'$Author\' "; $database_search = mysql_query("comps", $query_database_search) or die(mysql_error()); does anyone know what i\'m doing wrong here? Thank you