RE: [PHP-DB] Calculating inside query?
| From: | USA) | Date: | Wed, 10 Jul 2002 16:36:20 +0000 |
| Subject: | RE: [PHP-DB] Calculating inside query? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20461@lists.php.net to get a copy of this message | ||
i assume you're using MySQL because of the Limit clause, but what error are you receiving?
-----Original Message-----
From: andy [mailto:news.letters@gmx.de]
Sent: Wednesday, July 10, 2002 10:34 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Calculating inside query?
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 see the error:
Mysql:
SELECT
ID,
rating_total / ratings_amount AS top10
FROM rating
ORDER BY top10 desc
LIMIT 10
Thanx for any help,
Andy
query
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php