如何使用php从我的数据库中获取数据到<td id =“myId”>？

Question

I have created a table of empty cells as follows

$sql1 = mysqli_query($mysqli,"SELECT * FROM production WHERE date(productiondate)='".$today."' AND productionline=1");

echo "<tr>";
        echo "<td>Row #1</td>";
        for($i=8;$i<=20;$i++)
        {
            echo "<td id=".$i."></td>";
        } echo "<td></td>";

Now I want to insert values into specific cells according to their ids, but unable to do so since the following function will insert them serially.

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

        echo "<td>".$row['productionquantity']."</td>";

        }

        echo "</tr>";

Any help will be greatly appreciated. And please let me know if any other snippets of my code are required to get a better understanding of my motive.

Answer 1

Do you have any $sql2 variable? Because your mysqli_fetch_array() gets an "$sql2 parameter.