如何使用PHP和MySQL在序列中显示DB值

Question

I need one help.I need to display values inside table using PHP and MySQL.I am explaining my code below.

<?php 
$sql=mysql_query("select * from phr_pincode order by id desc");

while($row=mysql_fetch_array($sql)){
    echo 
      '<tr>
       <td></td>
    <td>'.$row['pincode'].'</td>
      <td>'.$row['area'].'</td>
    <td>'.$row['status'].'</td>
     <td>

     <a>
    <input type='button' class='btn btn-xs btn-green' value='Edit'">  
    </a>
    </td>
    <td>
    <a>
    <input type='button' class='btn btn-xs btn-red' value='Remove'>  
    </a>
     </td>
    </tr>';
    }
?>

Here I am getting some syntax errors.I need here all data to display in a loop.I have left first row,it should take serial no (1,2,3....) and for edit button i need to attach index.php with the respective id after ? inside anchor tag.

Answer 1

    <?php 
    $sql=mysql_query("select * from phr_pincode order by id desc");

        while($row=mysql_fetch_array($sql)){
    ?>
<tr>
           <td></td>
        <td><?=$row['pincode']?></td>
          <td><?=$row['area']?></td>
        <td><?=$row['status']?></td>
         <td>

         <a>
        <input type='button' class='btn btn-xs btn-green' value='Edit'">  
        </a>
        </td>
        <td>
        <a>
        <input type='button' class='btn btn-xs btn-red' value='Remove'>  
        </a>
         </td>
        </tr>
    <?php
        }
    ?>

Use of (') is might be getting issue when it's come next (') it will automatically close.. so use this practice....