Código:
Gracias if ( ! empty($vte)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND A.telefonos='$vte') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE telefonos='$vte' ) UNION ALL (SELECT 2 as qnum,U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND U.telefonos='$vte')"; } if ( ! empty($movil)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND A.movil='$movil') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE movil='$movil' ) UNION ALL (SELECT 2 as qnum,U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND U.movil='$movil')"; } if ( ! empty($dni)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND A.dni='$dni') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE dni='$dni' ) UNION ALL (SELECT 2 as qnum,U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND U.dni='$dni')"; } if ( ! empty($calle)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND B.calle like '%$calle%') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE calle like '%$calle%') UNION ALL (SELECT 2 as qnum, U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND D.calle like '%$calle%')"; } if ( ! empty($ape)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND A.apellidos like '%$ape%') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE apellidos like '%$ape%') UNION ALL (SELECT 2 as qnum, U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND U.apellidos like '%$ape%')"; } if ( ! empty($name)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND A.name like '%$name%') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE name like '%$name%') UNION ALL (SELECT 2 as qnum, U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND U.name like '%$name%')"; } if ( ! empty($loca)) { $sql ="(SELECT 0 as qnum,A.id_aviso,A.telefonos,A.telefonos3,A.movil,A.dni,A.name,A.apellidos,B.localidad,B.calle FROM clientes A,dir_clientes B WHERE A.id_aviso=B.id_aviso AND B.calle != '' AND B.localidad like '%$loca%') UNION ALL (SELECT 1 as qnum,id_aviso,telefonos,telefonos3,movil,dni,name,apellidos,localidad,calle FROM avisos WHERE localidad like '%$loca%') UNION ALL (SELECT 2 as qnum, U.id_aviso,U.telefonos,U.telefonos3,U.movil,U.dni,U.name,U.apellidos,D.localidad,D.calle FROM usuarios U,dir_usuarios D WHERE U.id_aviso=D.id_aviso AND D.calle != ''AND D.localidad like '%$loca%')"; }