inner join query don't return any things

Question

I have a php code that use a mySQL query in it. tables users and conversation and main_profile have true values to select after this query but query return nothing.

$sqlQuer = 
"SELECT `conversation`.from,`conversation`.text, `main_profile`.nik_name, `users`.id  
FROM `conversation` 
INNER JOIN `users` ON(`users`.username = `conversation`.to ) 
INNER JOIN `main_profile` ON(`users`.id = `main_profile`.user_id) 
WHERE `conversation`.to = '".$to."' 
AND `conversation`.read = '0'";

$result = mysql_query( $sqlQuer) or die (mysql_error());
while($row = mysql_fetch_array($result))
{
    echo $row[0] . "#TEXT#" . $row[1]. "#TEXT#" . $row[2] . "#CON#";
    $ids[] = $row['id'];
}

any Idea ?

please refer this link ..http://stackoverflow.com/questions/5706437/whats-the-difference-between-inner-join-left-join-right-join-and-full-join — Nishant Solanki, Apr 24 '14 at 07:09
there seems nothing wrong with the query. can you provide the data sample you test with ? — d.raev, Apr 24 '14 at 07:12
http://stackoverflow.com/questions/5706437/whats-the-difference-between-inner-join-left-join-right-join-and-full-join — Nishant Solanki, Apr 24 '14 at 07:12
and why are you echoing `$row[0] , $row[1]`??? you should echo `$row['text'] , $row['from']`.... as per your query... — Nishant Solanki, Apr 24 '14 at 07:21
@NishantSolanki why it is wrong i have an array and can use index. — MohammadReza Vahedi, Apr 24 '14 at 07:22
@MohammadRezaVahedi hmm sorry.. as `mysql_fetch_array` returns both `associative and numeric array`.. but have you tried left join or not?? — Nishant Solanki, Apr 24 '14 at 07:28

score 1 · Answer 1 · answered Apr 24 '14 at 08:02

1

Query was solved with this change that First INNER JOIN changed to LEFT JOIN and second changed to RIGHT JOIN.

answered Apr 24 '14 at 08:02

MohammadReza Vahedi

741
8
17

inner join query don't return any things

1 Answers1