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