mysqli_fetch_assoc() expects parameter 1 to be mysqli_result when trying to select from different tables

Question

i am trying to select 2 values from 2 different tables and getting this error. when i only selected from 1 table its worked. this is my code (after changing it already when looking on answers to this problem n line):

$apartmentNum = $_GET['apartmentNumber'];



$getBillsSumQuery = "SELECT a.totalBillsAmount , b.count(id) FROM apartments AS a , bills AS b WHERE a.number = "'.$apartmentNum.'" AND b.apartmentNumber = '.$apartmentNum.'";

$totalSum = mysqli_query($con,$getBillsSumQuery);

$row = mysqli_fetch_assoc($totalSum); //this is where the program crushes

$newSum = $row['totalBillsAmount'];

$billsCount = $row['count(id)'];


echo '{"billSum":' . $newSum . ' , "billCount":' . $billsCount .'}';

score 0 · Answer 1 · answered Jun 13 '16 at 08:35

0

You need to write count(b.id) instead of b.count(id). Use below query.

$getBillsSumQuery = "SELECT a.totalBillsAmount , count(b.id) FROM apartments AS a , bills AS b 
WHERE a.number = "'.$apartmentNum.'" AND b.apartmentNumber = '.$apartmentNum.'";

answered Jun 13 '16 at 08:35

RJParikh

4,096
1
19
36

thank you i didnt noticed it. but its not the answer to my error, the problem still exists – A.T Jun 13 '16 at 08:39
Use join to connect 2 tables. @A.T – RJParikh Jun 13 '16 at 08:43

mysqli_fetch_assoc() expects parameter 1 to be mysqli_result when trying to select from different tables

1 Answers1