dongzhao4036 2015-05-08 16:06
浏览 39
已采纳

从数据库的两个表中检索数据并使用php显示它[关闭]

I have created a database named (insert) having two tables table1 and table 2.

table1 have 3 columns user, id, roll.

table2 have 2 columns id, menu.

I have inserted values in two tables. I want to retrieve all values from two tables and show them in another php file, but my query is not working. It's showing error. What should I do? here is my code

<?php

include 'insertjoincon.php';
$sql = "SELECT table1.user, id FROM table1, table2 WHERE    table1.id=table2.id";

echo "<table border=1>
<tr><th>Name</th><th>ID</th></tr>
";

while ($line = mysql_fetch_array($sql)) {
    $name = $line["user"];
    $id = $line["id"];
    echo "<tr>";
    echo "<td>" . $name . "</td>";
    echo "<td>" . $id . "</td>";
    echo "</tr>";

    echo "</table>";
}

$conn->close();
?>
  • 写回答

3条回答 默认 最新

  • douchui4459 2015-05-08 16:45
    关注

    (Edit: The first few sentences are incorrect. In my first glance I saw that you specified a table for one column but missed that you didn't specify a table for id. Because they share the same value, pick one table and specify it. You should always specify table with either explicit or implicit JOINS. Still, first thing's first).

    I'm guessing your query actually works if you test it. There is nothing inherently wrong with your query (although I always recommend using explicit JOINS).

    There is a good reason why the example code you're providing would not work...

    You're missing $result = mysqli_query($sql):

    Yok can then use mysqli_fetch_array($result).

    mysqli_fetch_array() expects a result, not a SQL string.

    Please note that you should use mysqli not mysql.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?