Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if( empty($this->data['sexo']))
- {
- $sexoClause = " ";
- }
- else
- {
- $sexoClause = candidatos.sexo = mysql_real_escape_string($this->data['sexo']);
- }
- $giros = $this->data['giroexperiencia'];
- $candidatos= $this->Candidatosvacante->query("
- SELECT candidatos.id,
- candidatos.sexo,
- candidatos.fechanacimiento,
- candidatos.ciudadorigen,
- candidatos.giroexp,
- candidatos.queofrecealaempresa,
- users.username,
- infopersonales.escgrado
- FROM
- candidatos
- JOIN users on(users.id = candidatos.user_id)
- left JOIN infopersonales on(infopersonales.candidato_id = candidatos.id)
- where 1 and
- {$sexoClause}"
Add Comment
Please, Sign In to add comment