|
SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
![]() |
|
Alati teme | Način prikaza |
|
![]() |
#1 |
član
Certified
Datum učlanjenja: 05.11.2005
Poruke: 82
Hvala: 7
1 "Hvala" u 1 poruci
![]() |
![]() |
![]() |
![]() |
![]() |
#2 |
član
Certified
Datum učlanjenja: 25.07.2008
Poruke: 76
Hvala: 15
296 "Hvala" u 10 poruka
![]() ![]() ![]() ![]() |
![]() PHP kôd:
![]() |
![]() |
![]() |
![]() |
#3 |
član
Certified
Datum učlanjenja: 25.07.2008
Poruke: 76
Hvala: 15
296 "Hvala" u 10 poruka
![]() ![]() ![]() ![]() |
![]() |
![]() |
![]() |
![]() |
#4 |
član
Certified
Datum učlanjenja: 25.07.2008
Poruke: 76
Hvala: 15
296 "Hvala" u 10 poruka
![]() ![]() ![]() ![]() |
![]() Da li ovo valja?
Kôd:
SELECT * FROM ( SELECT users.username, users.image, messages.message, messages.sender, message_discussion.mid FROM message_discussion, messages, users WHERE messages.disc_id = message_discussion.mid AND ( users.id = message_discussion.user_1 OR users.id = message_discussion.user_2 ) AND users.id != '2' AND ( message_discussion.user_1 = '2' OR message_discussion.user_2 = '2' ) ORDER BY messages.timer DESC ) AS tabler GROUP BY tabler.mid DESC ![]() |
![]() |
![]() |
![]() |
|
|