Re: prepared statement syntax problem

[Dimitris Papageorgiou]

this is my latest iteration...but I do not know where to go from here:
$st=$connection->prepare('set @arg = ?%');
$st->bind_param('s',$query);//this is the search string
$st->execute();

stmt = $connection->prepare('select u.name,u.lastname,t.user_type
from users u
join business_users b on u.user_id=b.crid
join buz_usertype t on b.bus_user_type=t.type_id
where u.lastname like=?%')
etc...etc...