PHP MySQL query with variable -

i have problem query:

$result = $this->database->prepare("select * kunden partner = '$pname'"); 

can write query right?

try way

$result = $this->database->prepare("select * kunden partner = '".$pname."'");