search by lastname

$con = db_connect();if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db($dbname, $con);$result = mysql_query('SELECT * FROM Customers WHERE LastName LIKE '%" . $lname . "%'";);        while($row = mysql_fetch_array($result)) {                echo "$row[LastName]";        };mysql_close($con);