phpbar.de logo

Mailinglisten-Archive

Re[2]: Nochmal Hitliste
Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re[2]: Nochmal Hitliste



Hi!

Cyrill Schumacher <webmasterbhs_(at)_bluewin.de> schrieb:
> select a.Autoren as aa,distinct(b.AutorID) as dba,count(b.AutorID) as cba
>>from Autoren as a, Artikel as b
> where a.ID = b.AutorID
> group by dba
> order by cba asc
Hi!

So leid es mir tut, ich kriege folgenden Fehler:

MySQL meldet: You have an error in your SQL syntax near 'DISTINCT(b.Autor) as dba, COUNT(b.Autor) as cba from Members as a, Artikel as b ' at line 1

Malte
-- 
[ - - - - - - - - - - - - - - - - - - - - - - - - - - ]
[ malte schomers | mschomers_(at)_gmx.de | www.malte.de.cx ]
[ icq#: 39453721 | odigo id: 202551 ->  www.odigo.com ]
[ - - - - - - - - - - - - - - - - - - - - - - - - - - ]


---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe


Home | Main Index | Thread Index

php::bar PHP Wiki   -   Listenarchive