multiple sql queries on single php page

Question

I have this code

 <?php
include("db.php");
$sql="select * from lead";
$result=mysqli_query($conn, $sql);
$i=0;
 ?>
 <?php while($row=mysqli_fetch_array($result)) { 
if($row['del']==1){ 
$sql1="select count(*) from notes where lead_id='$row[lead_id]'";
$var=mysqli_query($conn,$sql1);
                $var=mysqli_query($conn,$sql1);
                $var1=mysqli_num_rows($var);
?>

and below this php code is table which displays the data fetched by $row.The problem is I am not getting the correct count of rows.It shows 1 but I have multiple rows with same lead id

Nobody will stop you to use even 100 of them. Just make sure you do what you want — Nabin
– Nabin, Commented Jul 30, 2015 at 8:26

VladutZzZ · Accepted Answer · 2015-07-30 08:55:15Z

1

You call for $sql1="select count(*) from notes where lead_id='$row[lead_id]'";
and you have
$var=mysqli_query($conn,$sql1); $var1=mysqli_num_rows($var);
But that mysql_query will return only one row with count(*).
So you have to do
$sql1="select * from notes where lead_id='$row[lead_id]'";
and call
mysqli_num_rows($var);

answered Jul 30, 2015 at 8:55

VladutZzZ

7201 gold badge9 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fnkr · Accepted Answer · 2015-07-30 09:54:30Z

0

change

$var=mysqli_query($conn,$sql1);

to

$var = mysqli_multi_query($conn, $sql1);

edited Jul 30, 2015 at 9:54

fnkr

10.2k6 gold badges58 silver badges63 bronze badges

answered Jul 30, 2015 at 8:36

Daniel Krom

10.1k3 gold badges47 silver badges45 bronze badges

1 Comment

Prabhjot Singh Kainth Over a year ago

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean. It gives this error

Collectives™ on Stack Overflow

multiple sql queries on single php page

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related