在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?

Answer 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>';
    ....