. I actually created a test and it worked fine, just
copied your query.
<>< Ryan
-Original Message-
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Calculating inside query?
there is no error, it just does n
o: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Calculating inside query?
there is no error, it just does not pull out the right values. Just puts out
10 listings and the top10 column (as I named it by alias) contains no value.
I am using mysql.
maybe this has to do somehting with the alias?
"Ryan Ja
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
i assume you're using MySQL because of the Limit clause, but what error are
you receiving?
-Original Message-
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] C
i assume you're using MySQL because of the Limit clause, but what error are you
receiving?
-Original Message-
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Calculating inside query?
Hi there,
I would like to
Hi there,
I would like to find out the top 10 of some ratings. There are 2 columns.
One for the rating and one for the amount of ratings.
To find out the top 10 I would have to divide those 2 values and sort it.
Somehow this does not work. I do not have a clue why. Maybe someone of you
guys do s