jason360 Posted April 12, 2014 Share Posted April 12, 2014 Hey guys, I am trying to make two queries providing $result and $result2. I would like to subtract the two results to create a total for the vote (negative vote being possible). Therefore on an empty query the result value would have to be zero. My subtraction function isn't working. Does anyone know what I am doing wrong? I am getting no result. Thanks in advance! My code: $result = mysql_query('SELECT COUNT(*) FROM comment_votes WHERE vote_com_writer_id = "'.$d['user_id'].'" AND vote_com_rank = "1"'); $positive_votes = mysql_result($result, 0); $result2 = mysql_query('SELECT COUNT(*) FROM comment_votes WHERE vote_com_writer_id = "'.$d['user_id'].'" AND vote_com_rank = "2"'); $negative_votes = mysql_result($result2, 0); list($vote) = $positive_votes - $negative_votes; Link to comment https://forums.phpfreaks.com/topic/287709-subtracting-query-values/ Share on other sites More sharing options...
jason360 Posted April 12, 2014 Author Share Posted April 12, 2014 Problem solved: $result = mysql_query('SELECT COUNT(*) FROM comment_votes WHERE vote_com_writer_id = "'.$d['user_id'].'" AND vote_com_rank = "1"'); $positive_votes = mysql_result($result, 0); $result2 = mysql_query('SELECT COUNT(*) FROM comment_votes WHERE vote_com_writer_id = "'.$d['user_id'].'" AND vote_com_rank = "2"'); $negative_votes = mysql_result($result2, 0); $vote = $positive_votes - $negative_votes; Link to comment https://forums.phpfreaks.com/topic/287709-subtracting-query-values/#findComment-1475854 Share on other sites More sharing options...
mac_gyver Posted April 12, 2014 Share Posted April 12, 2014 run the following (untested) single query and fetch the total from the result set - $query = "SELECT SUM(CASE vote_com_rank WHEN 1 THEN 1 WHEN 2 THEN -1 ELSE 0 END) as total FROM comment_votes WHERE vote_com_writer_id = {$d['user_id']}"; Link to comment https://forums.phpfreaks.com/topic/287709-subtracting-query-values/#findComment-1475855 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.