$sql='SELECT a.serial_num user_serial FROM device a WHERE (LOWER(a.name) = ? OR a.mgmt_ip_addr = ?)';
$cmd = $dbh->prepare($sql);
$cmd->execute('test','test');

while ($row = $cmd->fetchrow_hashref())
{
	.....

}