xwishmasterx Posted March 2, 2013 Share Posted March 2, 2013 Hello I am having difficulties getting the right result (basically I get the value "0") when trying to get the right value. $result=mysql_query("SELECT ((Kind*$a_kind)+(Nice*$a_nice)+(Brave*$a_brave)+(Caring*$a_caring)) as total, Chars FROM char_game_chars GROUP BY Chars ORDER BY total ASC LIMIT 1") From above code, the $a_kind,*$a_nice,*$a_brave and $a_caring depends on users answers, ans should get the "Chars" value that corresponds to the highest sum. How would I create the right expression to calculate the right value? Quote Link to comment https://forums.phpfreaks.com/topic/275120-how-to-do-multiply-or-similar-with-variables/ Share on other sites More sharing options...
Barand Posted March 2, 2013 Share Posted March 2, 2013 We haven't a clue what is in your data or what the right value is. What is the problem? Quote Link to comment https://forums.phpfreaks.com/topic/275120-how-to-do-multiply-or-similar-with-variables/#findComment-1416084 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.