Re: script para hacer coincidir registros
| From: | Angel Fenoy | Date: | Fri, 22 Sep 2000 10:17:51 +0000 |
| Subject: | Re: script para hacer coincidir registros | ||
| References: | 1 2 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-1840@lists.php.net to get a copy of this message | ||
Angel Fenoy escribió:
> $q = "SELECT * FROM sys_perfiles where
> id_perfil != $duser->id_perfil AND
> ojos = $duser->b_ojos OR
> cabello = $duser->b_cabello OR
> signo = $duser->b_signo OR
> altura BETWEEN b_altura1 AND b_altura2
> edad BETWEEN b_edad1 AND b_edad2";
>
Falta un 'OR' después de 'altura BETWEEN b_altura1 AND b_altura2'
debe ser así:
$q = "SELECT * FROM sys_perfiles where
id_perfil != $duser->id_perfil AND
ojos = $duser->b_ojos OR
cabello = $duser->b_cabello OR
signo = $duser->b_signo OR
altura BETWEEN b_altura1 AND b_altura2 OR
edad BETWEEN b_edad1 AND b_edad2";
Un saludo
Àngel