RE: [PHP-DB] Calculating inside query?
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 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [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] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Calculating inside query?
do both of the fields contain values and are they both numeric? It sure seems strange to me. 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 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 Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [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] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Calculating inside query?
oh I see! There have been '' values in some columns. Thanx Andy Ryan Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... do both of the fields contain values and are they both numeric? It sure seems strange to me. 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 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 Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [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] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
