-2

I have written this code for fetch data from MySQL Server. There is an error, how to fix it?

<?php 
$status=$_GET['status'];

if ($status=="disp") {

    $link=mysqli_connect("localhost","root","");
    mysqli_select_db($link,"mainstock");
    $res=mysqli_query($link,"SELECT * FROM 1st_year");

    echo "<table>";

    while ($row=mysqli_fetch_array($res)) {
        echo "<tr>";
            echo "<td>";  echo $row=["id"];  echo "</td>";
            echo "<td>";  echo $row=["BooksName"];  echo "</td>";
            echo "<td>";  echo $row=["Avaibality"];  echo "</td>";
            echo "<td>";  echo $row=["Price"];  echo "</td>";
            echo "<td>";  echo $row=["Quantity"];  echo "</td>";
        echo "</tr>";
    };
    echo "</table>";

}
?>

Error in line 14, 15, 16, 17 which are

echo "<td>";  echo $row=["id"];  echo "</td>";
echo "<td>";  echo $row=["BooksName"];  echo "</td>";
echo "<td>";  echo $row=["Avaibality"];  echo "</td>";
echo "<td>";  echo $row=["Price"];  echo "</td>";
echo "<td>";  echo $row=["Quantity"];  echo "</td>";

Please help me!

Alive to die - Anant
  • 70,531
  • 10
  • 51
  • 98
Imran
  • 1
  • 2

1 Answers1

-1
        echo "<td>". $row["id"] . "</td>";
        echo "<td>".  $row["BooksName"]. "</td>";
        echo "<td>".  $row["Avaibality"] . "</td>";
        echo "<td>" . $row["Price"]; . "</td>";
        echo "<td>".  $row["Quantity"]; . "</td>";

fix these lines like above

Yahya Ayyoub
  • 322
  • 2
  • 10