I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you will need to make another table to count the hits per category.
Then do a join between the two tables to get the results you want.
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]
p://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 4:37 PM
Subject: Re: hits
> I don't think mysql has
ROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 4:17 PM
Subject: Re: hits
> UPDATE tbl SET Number = Number + 1 WHERE blah;
>
>
>
> Alex Behrens wrote:
> >
> > Hey Guys,
> >
> >
UPDATE tbl SET Number = Number + 1 WHERE blah;
Alex Behrens wrote:
>
> Hey Guys,
>
> I'm working on a script that displays reviews by a category for my site and
> I want the pull-down menu to be ordered by the amount of hits each category
> or review
> has, is it possible to sort by the amoun
