Yes, I figured it out right after I posted that, doh!
-Original Message-
From: Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:09 PM
To: Jason Lane; [EMAIL PROTECTED]
Subject: Re: How can I get a top ten total count from a table?
I guess this is what you want
I'm trying to retrieve the top ten entries of a total count from a
table. If I use the following select statement without the 'ORDER BY'
clause it returns the totals but not in any sort of order. But when I
add the 'ORDER BY' clause in it returns nothing.
Is there a way to structure the query to
I have a mysql table that has the primary key set to auto-increment. For
a
very strange reason we have a row with the primary key value of 0. This
is like a default value for the application. I didn't want to do it this
way, but it's too late now.
If the 0 value doesn't exist we have to create it
