Zitat:

Name: Wasweisich
Spalten: ID_Eintrag 1
ID_Eintrag 2

Zitat:

Name: Eintraege
Spalten: ID
Daten
Erstelldatum

Zitat:

SELECT
Daten as Eintrag1_Daten
Erstelldatum as Eintrag1_Erstelldatum
Daten as Eintrag2_Daten
Erstelldatum as Eintrag2_Erstelldatum
FROM
Wasweisich
WHERE
Wasweisich.ID_Eintrag1=Eintraege.ID
AND
Wasweisich.ID_Eintrag2=Eintraege.ID
//Hier das Problem
SORT BY
Wasweisich.Erstelldatum DESC

Zitat:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) as postcount FROM threads, section, use' at line 13
Fehlercode:1064

Zitat von uwebaier:

OK, Laut meiner Logik Problem gelöst...
ABER:
Ich darf jemanden bitten in diesem Query den Syntaxfehler bei COUNT(*) zu finden...

SELECT
threads.closed,
threads.pinned,
section.section,
section.name,
section.categorie,
user_first.ID as createrID,
user_first.nick as creater,
post_first.createDate,
user_last.ID as lasteditorID,
user_last.nick as lasteditor,
post_last.createDate as lastedit,
posts.COUNT(*) as postcount
FROM
threads,
section,
users as user_first,
users as user_last,
posts as post_first,
posts as post_last,
posts
WHERE
threads.section='home'
AND
section.section=threads.thread
AND
post_first.ID=threads.firstpost
AND
user_first.ID=post_first.creater
AND
post_first.ID=threads.lastpost
AND
user_last.ID=post_last.creater
AND
threads.thread=posts.section
SORT BY
post_last.createdate DESC
LIMIT
0, 15;

Den Error gibts natürlich auch...


1 Fehler gefunden =)
Heißt ORDER BY und nicht SORT BY xD

Aber der andere is immer noch da