Help with a Query

[Anon]

Hypothetically speaking, say I have a table called users with the following integer fields: clicks and votes.

How would I make the following SQL query work:

SELECT FROM users ORDER BY clicks votes DESC

Basically I want it to multiply the fields and then sort them by what was multiplied.

If you have any suggestions, let me know!

Thanks, you guys rock!

Joey

[Anon]

SELECT FROM users ORDER BY (clicks votes) DESC

🙂
- Fredrik

[Anon]

Sadly enough, that didn't work!

🙁

[Anon]

I'm running mysql 3.23.21-beta-debug and it works for me.

• Fredrik

[Anon]

This may work, but I haven't tried it:
use just a regular select staemtnet like SELECT from users
while ($row = mysql_fetch_array($result)) {
$compute = ($row["clicks"] $rwo["votes"]);
$array[$compute] = $row["clicks"].",".$row["votes"];
}
ksort($array);

while (list($key, $val) = each ($array)) {
$data = explode(",", $val);
print "clicks = ". $data[0] . " votes = ". $data[1] ."<br>";
}

[Anon]

here is my exact query:

doesn't work. weird. any other suggestions or what might be wrong with my query?

SELECT FROM ppusers WHERE done = '1' AND gender = '2' ORDER BY (clicks votes) DESC LIMIT 0, 5