Adding two fields in php

Question

$result = mysql_query("SELECT * FROM productlist1 order by pdesc ASC");


while($row = mysql_fetch_array($result))
$sold=$row['psold'];
$left=$row['pleft'];
$all=$left + $sold;
  {
    echo '<tr>';

      echo '<td>'.$row['pcode'].'</td>';
      echo '<td>'.$row['pdesc'].'</td>';
       echo '<td>'.$row['date'].'</td>';
        echo '<td>'.$row['time'].'</td>';
      echo '<td><div align="center">'.$row['psold'].'</div></td>';
      echo '<td><div align="center">'.$row['pleft'].'</div></td>';
      echo '<td><div align="center">'.$row['pprice'].'</div></td>';
    echo '<td><div align="center">'.$all.'</div></td>';

i want to add the pleft and psold, the $all doesn't work at all... what would i do with this code?

mesutozer · Accepted Answer · 2014-03-24 07:11:09Z

1

You have a syntax error. You need to place following 3 lines inside brackets:

$sold=$row['psold'];
$left=$row['pleft'];
$all=$left + $sold;

like:

while($row = mysql_fetch_array($result))
  {
  $sold=$row['psold'];
  $left=$row['pleft'];
  $all=$left + $sold;
    echo '<tr>';
    ....

answered Mar 24, 2014 at 7:11

mesutozer

2,8591 gold badge15 silver badges13 bronze badges

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

Comments

Jenz · Accepted Answer · 2014-03-24 07:11:23Z

1

You have to put opening braces for while loop just after the while statement like.

while($row = mysql_fetch_array($result))
{
$sold=$row['psold'];
$left=$row['pleft'];
$all=$left + $sold;
  ...............

answered Mar 24, 2014 at 7:11

Jenz

8,3718 gold badges50 silver badges83 bronze badges

Comments

Dev · Accepted Answer · 2014-03-24 07:13:13Z

Put your addition inside while loop,

because outside while loop it doesn't work, because it does not get proper value

So , try like this

    <?php

    $result = mysql_query("SELECT * FROM productlist1 order by pdesc ASC");


    while($row = mysql_fetch_array($result))
    {
        $all=$row['psold'] + $row['pleft'];
        echo '<tr>';

          echo '<td>'.$row['pcode'].'</td>';
          echo '<td>'.$row['pdesc'].'</td>';
           echo '<td>'.$row['date'].'</td>';
            echo '<td>'.$row['time'].'</td>';
          echo '<td><div align="center">'.$row['psold'].'</div></td>';
          echo '<td><div align="center">'.$row['pleft'].'</div></td>';
          echo '<td><div align="center">'.$row['pprice'].'</div></td>';
        echo '<td><div align="center">'.$all.'</div></td>';

Mohan · Accepted Answer · 2014-03-24 07:19:17Z

0

Try this.

 $result = mysql_query("SELECT * FROM productlist1 order by pdesc ASC");

    while($row = mysql_fetch_array($result))
      {
    $sold=$row['psold'];
    $left=$row['pleft'];
    $all=$left + $sold;
        echo '<tr>';
          echo '<td>'.$row['pcode'].'</td>';
          echo '<td>'.$row['pdesc'].'</td>';
           echo '<td>'.$row['date'].'</td>';
            echo '<td>'.$row['time'].'</td>';
          echo '<td><div align="center">'.$row['psold'].'</div></td>';
          echo '<td><div align="center">'.$row['pleft'].'</div></td>';
          echo '<td><div align="center">'.$row['pprice'].'</div></td>';
        echo '<td><div align="center">'.$all.'</div></td>';
echo '</tr>';
    }

edited Mar 24, 2014 at 7:19

answered Mar 24, 2014 at 7:13

Mohan

16310 bronze badges

Comments

Ajay Gupta · Accepted Answer · 2014-03-24 07:15:30Z

-2

Try parsing the values to integer like

$all=intval($left)+intval($sold);

Yeah one more thing your while is misplaced!!

edited Mar 24, 2014 at 7:15

answered Mar 24, 2014 at 7:11

Ajay Gupta

1,2858 silver badges22 bronze badges

1 Comment

Ajay Gupta Over a year ago

why -1 for this answer??

Collectives™ on Stack Overflow

Adding two fields in php

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related