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