Argthtjtr

Good morning,

I 've been struggling with the simple task of creating a sum of numerical values from the database. What I want to do is to create a loop within another loop.

The first loop is fetching 'project' from database and report the values in a table on my page and the bracket closes after the last column of the page. Now the part that i want to do is to use the $id to fetch the values from 'budget' in the database, and the ones that have the project_id='$id' to sum and echo them in another cell of the same table.

My code so far is the following:

<?php   

include 'dbcon.php';



$query1=mysqli_query($con,"select * from project ORDER BY project_id ASC")or die(mysqli_error($con));

while ($row1=mysqli_fetch_array($query1)){

        $id=$row['project_id'];

        $total=0;

        $query = mysqli_query($con,"SELECT * FROM budget WHERE project_id='$id'");

        while ($row=mysqli_fetch_array($query)){

        $total=$total+$row['amount'];}

?>

<tr>

<td colspan="2"><?php echo $row1['project_name'];?></td>

<td><?php echo $total;?></td>

<td><?php echo $row1['project_status'];?></td>

</tr>

<?php }?>

Now what I am getting is 0 in the table and not the summary. I have also tryid some solution I found in the site like:

$query = mysqli_query($con,"SELECT sum(amount) as total FROM budget WHERE project_id='$id'");

No luck with that one either. Now i have two explanations. Either the loop within a loop is not build correctly by me (i believe that setting $id=$row1['project_id'] will push the project_id to the next loop and will not change until the second loop finishes) or i missing something really silly here...

You might need to change this. I think you are doing something wrong here:

 $id=$row['project_id'];

To this:

 $id=$row1['project_id'];

See edit code