Forum » Programiranje » 2 mySQL tabele
2 mySQL tabele
ahac ::
1)
SELECT usertext.id, usertext.title, usertext.date, usertext.authorID, usertext.points FROM usertext WHERE usertext.category=9 ORDER BY usertext.title
2)
SELECT usertext.id, usertext.title, usertext.date, usertext.authorID, usertext.points FROM usertext, user WHERE usertext.category=9 ORDER BY usertext.title
3)
SELECT usertext.id, usertext.title, usertext.date, usertext.authorID, usertext.points FROM usertext, user WHERE usertext.category=9 ORDER BY user.username
Primer 1 dela, 2 in 3 mi pa vsako vrstico vržeta po 5 krat. Kaj je narobe?
SELECT usertext.id, usertext.title, usertext.date, usertext.authorID, usertext.points FROM usertext WHERE usertext.category=9 ORDER BY usertext.title
2)
SELECT usertext.id, usertext.title, usertext.date, usertext.authorID, usertext.points FROM usertext, user WHERE usertext.category=9 ORDER BY usertext.title
3)
SELECT usertext.id, usertext.title, usertext.date, usertext.authorID, usertext.points FROM usertext, user WHERE usertext.category=9 ORDER BY user.username
Primer 1 dela, 2 in 3 mi pa vsako vrstico vržeta po 5 krat. Kaj je narobe?
Slo-Tech Discord - https://discord.gg/ppCtzMW
Vredno ogleda ...
| Tema | Ogledi | Zadnje sporočilo | |
|---|---|---|---|
| Tema | Ogledi | Zadnje sporočilo | |
| » | [SQL] Kazalci pri grupiranjuOddelek: Programiranje | 1005 (882) | Tody |
| » | sql injection [PHP + mysql]Oddelek: Informacijska varnost | 2123 (1848) | Lion29 |
| » | SQL seštevanjeOddelek: Izdelava spletišč | 1752 (1536) | pizdarija1 |
| » | MySQL združevanje tabel..Oddelek: Programiranje | 1917 (1732) | Nemenej |
| » | MySQL & PHP napaka..Oddelek: Programiranje | 1940 (1755) | lordgreg |