peizhao2017
V2EX  ›  问与答

新手小白问个 mysql_fetch_array 的问题

  •  
  •   peizhao2017 · May 8, 2018 · 1841 views
    This topic created in 3108 days ago, the information mentioned may be changed or developed.


    数据库中 tag_id=1 的有 5 项

    实际输出只有 4 项

    第一条哪去了呢

    代码
    while($total_row = mysqli_fetch_array($total_result))
    {
    echo $total_row['tag_id'] . " " . $total_row['topic_id'];
    echo "<br />";
    }
    6 replies  •  2018-05-08 09:42:00 +08:00
    msg7086
    msg7086
    May 8, 2018
    1
    请求的代码在哪呢。
    peizhao2017
    peizhao2017
    OP
    May 8, 2018
    2
    @msg7086 #1
    请求的代码
    $total_sql="SELECT * FROM topic_tag WHERE tag_id = 1";
    $total_result =mysqli_query($conn,$total_sql);
    $total_row=mysqli_fetch_row($total_result);
    msg7086
    msg7086
    May 8, 2018
    3
    $total_row=mysqli_fetch_row($total_result); 不就把第一行请求走了吗。
    while 里就从第二行开始读了呀?
    peizhao2017
    peizhao2017
    OP
    May 8, 2018
    4
    @msg7086
    谢谢
    原来如此
    怎么写才能获得第一行呢
    msg7086
    msg7086
    May 8, 2018
    5
    把这行多余的读取第一行然后扔掉的代码删掉。
    peizhao2017
    peizhao2017
    OP
    May 8, 2018
    6
    @msg7086 #5
    tks,搞定
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2286 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 24ms · UTC 00:13 · PVG 08:13 · LAX 16:13 · JFK 19:13
    ♥ Do have faith in what you're doing.