php - 查询返回资源 id #10

Question

我想显示具有特定列名的行数。当我执行查询时，没有显示错误，但给出的输出只是资源 id #10。我是php和mysql领域的初学者。谁能帮我吗 ？我尝试了下面给出的代码

    $sql ="SELECT column1,column2 FROM table1 WHERE user_id='name' GROUP BY time_stamp";    
    $result = mysql_query($sql);
    $count=1;
    while($row = mysql_fetch_array($result)) {
        echo "<form action=table2.php method=GET>";
        echo"<tr>";
        $row_no="SELECT COUNT(time_stamp) FROM table1";
        $row_num = mysql_query($row_no);



        echo "<td>" .$count. "</td>";
        echo "<td>" .$row["column1"]. "</td>";
        echo "<td>" .$row["column2"]. "</td>";
        echo "<td>" .$row_num. "</td>";
        echo "<td>" ."<input class=btn type=submit value=Delete". "></td>";

        echo"</tr>";
        echo "</form>";
        $count=$count+1;
    }

Answer 1

您需要在第二个查询中获取计数。您可以使用 mysql_fetch_row 来完成此操作

$sql ="SELECT column1,column2 FROM table1 WHERE user_id='name' GROUP BY time_stamp";    
    $result = mysql_query($sql);
    $count=1;
    while($row = mysql_fetch_array($result)) 
    {
        echo "<form action=table2.php method=GET>";
        echo"<tr>";
        $row_no= mysql_query("SELECT COUNT(time_stamp) as count FROM table1");
        $row_num = mysql_fetch_row($row_no);
        echo "<td>" .$row_num[0]. "</td>";
        echo "<td>" .$row["column1"]. "</td>";
        echo "<td>" .$row["column2"]. "</td>";
        echo "<td>" .$row_num. "</td>";
        echo "<td>" ."<input class=btn type=submit value=Delete". "></td>";
        echo"</tr>";
        echo "</form>";
        $count=$count+1; 
    } 

注意:不要使用 mysql_* 这些函数已被弃用。请改用 mysqli_* 或 PDO。