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? 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? 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
Archived
This topic is now archived and is closed to further replies.