PHP Query + IF ELSE

本文关键字：ELSE IF Query PHP | 更新日期: 2023-09-27

我有一个PHP文件做查询

function getFiles()
{
    $solnid = $_GET[id];
    $query = mysql_query("SELECT * FROM library WHERE libr_solutionId = '$solnid' AND libr_deleted IS NULL") or die(mysql_error());
    $result = mysql_query($query);
    if (mysql_num_rows($result)==0) {
        echo "<br>No Related Links";
    } else {
        while($library = mysql_fetch_assoc($query)) {
            echo "<span style='"margin-bottom: 5px;'"><a href='"Solutions/image/".$library[libr_solutionref]."/".$library[libr_filename]."'" target='"_blank'"><img src='"images/icon-download-02.png'" align='"absmiddle'" style='"margin-right: 5px;'"><span>".$library[libr_c_title]."</span></a></span><br>";
            echo "<br>";
        }
    }       
}

我已经在PHPMyAdmin中测试了查询，我得到了一个结果，但是当在我的页面上运行该函数时，它只显示"无相关链接"语句，任何人都有任何想法?

下面是修复后的代码。:)问题是你在一个资源上使用了mysql_query(第一个mysql_query)，这将给出0行，或者一个异常。

function getFiles()
{
    $solnid = $_GET['id'];
    $result = mysql_query("SELECT * FROM library WHERE libr_solutionId = '$solnid' AND libr_deleted IS NULL") or die(mysql_error());
    if (mysql_num_rows($result)==0) {
        echo "<br>No Related Links";
    } else {
        while($library = mysql_fetch_assoc($result)) {
            echo "<span style='"margin-bottom: 5px;'"><a href='"Solutions/image/".$library['libr_solutionref']."/".$library['libr_filename']."'" target='"_blank'"><img src='"images/icon-download-02.png'" align='"absmiddle'" style='"margin-right: 5px;'"><span>".$library['libr_c_title']."</span></a></span><br>";
            echo "<br>";
        }
    }       
}

将函数更改为(更改为lines)

function getFiles()
{
    $solnid = $_GET[id];
    $result = mysql_query("SELECT * FROM library WHERE libr_solutionId = '$solnid' AND libr_deleted IS NULL") or die(mysql_error());
    if (mysql_num_rows($result)==0) {
        echo "<br>No Related Links";
    } else {
        while($library = mysql_fetch_assoc($query)) {
            echo "<span style='"margin-bottom: 5px;'"><a href='"Solutions/image/".$library[libr_solutionref]."/".$library[libr_filename]."'" target='"_blank'"><img src='"images/icon-download-02.png'" align='"absmiddle'" style='"margin-right: 5px;'"><span>".$library[libr_c_title]."</span></a></span><br>";
            echo "<br>";
        }
    }       
}