mysql两列之和_从mysql数据库的两列之和计算pecent值

我正在尝试从两列中获取总值(我已经完成了这项工作),然后获取这些值并从中创建百分比。在这种情况下,我有一个加权值和一个总值。我需要知道我的加权值占总价值的百分比。

我试过:

$result = mysqli_query($mysqli, "SELECT SUM(WEIGHTEDV / VALUE) FROM test.service");

$result = mysqli_query($mysqli, "SELECT WEIGHTEDV, VALUE, (WEIGHTEDV / VALUE) AS percent FROM test.service;

$result = mysqli_query($mysqli,"SELECT (WEIGHTEDV / VALUE)*10 AS Percent

FROM test.service");

还有一些我不太记得的尝试。

下面是更完整的代码:

登录和工作值总和

//LOGIN INFO

$db_host = 'localhost';

$db_user = 'root';

$db_pw = "********";

$database = "test";

//LOGIN VARIABLE

$mysqli = new mysqli($db_host, $db_user, $db_pw);

//VERIFY LOGIN INTEGRITY

if ($mysqli === false) {

die("Cannot connect to Database Server" . $mysqli->connect_error);<