$query1 = 'select Name from Customers where CustId = :custid';
$query2 = 'select Name from Sales where SalesId = :salesid';

$sth1 = $dbh->prepare($query1);
$sth2 = $dbh->prepare($query2);

if ($x > 10) {
  $sth1->bind_param('custid', $custid);
  $sth1->execute();
  while ($row = $sth1->fetchrow_hashref) {
    ...
  }
} else {
  $sth2->bind_param('salesid', $salesid);
  $sth2->execute();
  while ($row = $sth2->fetchrow_hashref) {
    ...
  }
}

##</code><code>##

Like "prepare" except that the statement handle returned will be stored in a hash associated with the $dbh. If another call is made to "prepare_cached" with the same $statement and %attr parameter values, then the corresponding cached $sth will be returned without contacting the database server.