|
[ Autoren gesucht! ]
|
PHP-Homepage.de sucht laufend Autoren für News und Artikel
Interesse?
|
|
 |
|
[Start] [Suche] [Neue Einträge]
| JOIN |
<?PHP
CREATE TABLE foren (id INT(2) NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), forum_name VARCHAR(255), INDEX(id));
CREATE TABLE themen (id INT(4) NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), forum_id INT(2), title VARCHAR(255), INDEX(id));
foren
#id | forum_name
1 | Anfänger
2 | Fortgeschrittene
3 | Profis
themen
#id | forum_id | title
1 | 1 | anfängerthema
2 | 1 | anfängerthema2
[# = primary key]
SELECT foren.forum_name, count(themen.forum_id) AS counts FROM foren LEFT JOIN themen ON foren.id=themen.forum_id WHERE themen.forum_id=foren.id OR themen.forum_id IS NULL GROUP BY foren.id ORDER BY foren.forum_name
ergibt:
form_name | counts
Anfänger | 2
Fortgeschrittene | 0
Profis | 0
?> |
|
