Count and order by - error

I'm trying to count how many time
each user have been logged in to my website
and then sort them desc. But I keep getting
an error.

SELECT user, count(user) AS logins
FROM tsigninlog
GROUP BY user
order by logins desc;

This SQL shows a form where I must enter a parameter value.
Why does it not works ?


--
My Photo Gallery
www.anothermasterpiece.com
.

Relevant Pages

  • RE: permission
    ... I don't think it's a good idea to give any sort of access to the root. ... Your website shouldn't be on the system volume anyway. ... Stand Up For Free Speech ... will also take that permission, so if someone that knows what they're ...
    (Security-Basics)
  • Re: SteveH tilting like a good un tonight
    ... You mean you dish it out but can't take it, ... and don't netkkkop people when you can't handle it. ... Excellent post JAB, i think SteveH should have known how some people are in here, and to some seeing his website is plenty, never mind filling it with so much personal info and photos. ... If people want to put that sort of information up then they should limit access to it or be prepared for the sort of shite that goes on. ...
    (uk.sport.football.clubs.liverpool)
  • Re: SuSE on Compaq Presario
    ... > prefer an AMD system. ... Might be a damn good store but my first impression on the website is it seems ... (if anyone from that website is reading this do me a favour and sort the site ... Email is spam trap try baskitcaise at gmx dot co dot uk ...
    (alt.os.linux.suse)
  • Re: Best church websites
    ... So the designer concentrates on design, accessibility, cross-browser ... responsibility for keeping the content up to date, ... easy for them to have a useful website. ... then it sort of generalised itself..... ...
    (uk.religion.christian)
  • Re: Basic Mutlithreading Questions
    ... the website; ... My concern also is not so much keeping the 'SendEmails' thread alive, ... alive indefinately because of no timeout and some sort of sending hangup on ... do this waiting in new a calling thread (the 'MainSendEmailsThread' thread ...
    (microsoft.public.dotnet.framework.aspnet)