Query che non restituisce risultati

[blackskyisback]

Ciao a tutti

qualcuno mi spiega questo mistero,
questa query non restituisce niente nonostante il valore Linda Blair (I), Linda Denise Blair e' presente nella tabella actor.performer_aka

SET @variable = 'Linda Denise Blair';
SELECT
    actor.actor_id,
    actor.nome,
    actor.performer_aka,
    ptgweb.alias,
    ptgweb2.websites 
FROM
    ptgweb
    INNER JOIN actor ON ptgweb.actor_id = actor.actor_id
    INNER JOIN ptgweb2 ON actor.actor_id = ptgweb2.actor_id 
WHERE
    actor.performer_aka LIKE concat ('%',@variable,'%')
    OR 
        ptgweb.alias LIKE concat ('%',@variable,'%') 
    OR 
        ptgweb2.websites LIKE concat ('%',@variable,'%') 

[blackskyisback]

risolto

la parola magica e' LEFT JOIN

SET @variable = 'Linda Denise Blair';
SELECT
    actor.actor_id,
    actor.nome,
    actor.performer_aka,
    ptgweb.alias,
    ptgweb2.websites 
FROM
    actor
    LEFT JOIN ptgweb ON actor.actor_id = ptgweb.actor_id
    LEFT JOIN ptgweb2 ON actor.actor_id = ptgweb2.actor_id 
WHERE
    actor.performer_aka LIKE concat ('%',@variable,'%')
    OR ptgweb.alias LIKE concat ('%',@variable,'%')
    OR ptgweb2.websites LIKE concat ('%',@variable,'%') 

[blackskyisback]

caspita, pensavo di avere risolto ed invece altri problemi

neella ricerca il secondo risultato appare senza id (actor_id)



non capisco che succede

ecco la query

<?php
$_POST['input_nome']=trim($_POST['input_nome']); // funzione per eliminare spazi vuoti
$value = $_POST["input_nome"];
//$query = mysql_query ("SELECT nome FROM attrici WHERE nome = '".$value."'", $db);
$query = mysql_query ("
SELECT
actor.*, 
ptgweb.*, 
ptgweb2.*
FROM actor  
LEFT JOIN ptgweb ON actor.actor_id = ptgweb.actor_id
LEFT JOIN ptgweb2 ON actor.actor_id = ptgweb2.actor_id
WHERE 
(nome LIKE '%" . $value . "%') 
OR (performer_aka LIKE '%" . $value . "%') 
OR (career_status LIKE '%" . $value . "%')
OR (start LIKE '%" . $value . "%')
OR (end LIKE '%" . $value . "%')
OR (ptgweb.alias LIKE '%" . $value . "%')
OR (ptgweb2.websites LIKE '%" . $value . "%')
", $db);

?>

[blackskyisback]

risolto l'errore era in questo punto

ptgweb.*, 
ptgweb2.* 

siccome anche in queste 2 tabelle era presente il campo actor_id la query entrava in conflitto

risolto cosi

ptgweb.alias, 
ptgweb2.websites 

NOTA: La ricerca FULLTEXT e' abilitata in certi campi

query completa funzionate,

SELECT
actor.*, 
ptgweb.alias, 
ptgweb2.websites
FROM actor  
LEFT JOIN ptgweb ON actor.actor_id = ptgweb.actor_id
LEFT JOIN ptgweb2 ON actor.actor_id = ptgweb2.actor_id
WHERE 
actor.nome LIKE  ('%" . $value . "%')
OR actor.performer_aka LIKE  ('%" . $value . "%')
OR ptgweb.alias LIKE  ('%" . $value . "%')
OR ptgweb2.websites LIKE  ('%" . $value . "%')
OR actor.career_status LIKE  ('%" . $value . "%')
OR actor.start LIKE  ('%" . $value . "%')
OR actor.end LIKE  ('%" . $value . "%')