Inner Join

[durie]

Ce este gresit aici? mentionez ca acest lucru sa fie inclus " username='$username' "

$query = mysql_query("SELECT * FROM friends INNER JOIN register_users WHERE username='$username' AND email='$email' ORDER BY username DESC");

tabelele mele sunt "register_users"
cu fieldurile id, username, email, parola, imagineavatar

si tabelul "friends"
cu fieldurile id, numeprieten, username

Orice raspuns dat este binevenit, va multumesc anticipat! Cel mai tare forum..mult noroc in continuare.

[Bogdan Citoiu]

cum arata tabelele tale?
INNER JOIN intre cele 2 tabele ar trebui sa le faci dupa un camp.
ceva de genul:
SELECT * FROM friends INNER JOIN register_user ON friends.ceva_camp = register_user.ceva_camp WHERE username='$username' AND email='$email' ORDER BY username DESC
sau
SELECT * FROM friends, register_user WHERE friends.ceva_camp = register_user.ceva_camp AND username='$username' AND email='$email' ORDER BY username DESC

[Cedik]

Daca rulezi acea comanda in Phpmyadmin sau alt program similar, ce eroare iti da?

[martynesku]

nu ai precizat campul FOREIGN KEY folosit pentru join

[Cristi G]

Foloseste asta:

SELECT * FROM friends f INNER JOIN register_users ru ON f.username = ru.username WHERE ru.username='$username' AND ru.email='$email' ORDER BY ru.username DESC 

[durie]

Multumesc Cristi G, merge!
Dar nu merge LIMIT-ul..

SELECT * FROM friends f INNER JOIN register_users ru ON f.username = ru.username WHERE ru.username='$username' AND ru.email='$email' ORDER BY ru.username DESC LIMIT 8

[Cristi G]

Ai incercat in phpmyadmin?