Запрос типа такого:
Код: Выделить всё
select Alarms.Id, typeId, Alarms.Date, Time, Description, Who_reg, Channel_new.Name, Street, Home, Office,
typeName, StatusName, Id_point, Channel_new.Id, Duration, Done from Alarms left join Channel_new on Channel_new.id=Alarms.id_ch
left join StatusTypes on StatusTypes.id = Alarms.Done
left join AlarmTypes on AlarmTypes.id = Alarms.typeId where Channel_new.Name like '%$client%' or CONCAT(Channel_new.Street,' ',Channel_new.Home) like '%$client%' and Alarms.Id_ch = '$alarm_n' and Alarms.typeId = '$alarm_type'