Inner Join

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.

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

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

nu ai precizat campul FOREIGN KEY folosit pentru join

Foloseste asta:

Cod PHP:

---

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 


---

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

Ai incercat in phpmyadmin?