插入只做第一行

Question

我有一个简单的查询，它从我的数据库中返回一些结果，它返回 4 行，但是当我执行插入时，它只执行第一行然后停止，似乎没有为从返回的每一行执行插入第一个查询。

$sql = "SELECT t.ID AS 'TopicID', t.seminar_id AS 'SeminarID', rl.resourceid AS 'ResourceID', r.ResourceType AS 'ResourceType'

        FROM topic t

        LEFT JOIN resourcelink rl ON rl.entityid = t.ID

        LEFT JOIN resources r ON r.ResourceID = rl.resourceid

        WHERE t.seminar_id = '124840'";

$result = mysql_query($sql);

// echo "<pre>";

// print_r($sql);

// echo "</pre>";

while($row = mysql_fetch_assoc($result))

{

    $resourceID = $row['ResourceID'];

    $resourceType = $row['ResourceType'];

    if ($resourceID != '' && $resourceType != 1)

    {

        $sql_insert = "INSERT INTO resourcelink (resourceid, entityid, entitytype, linkorder, viewinplayer)

                VALUES ($resourceID, $topicID, 1, 0, 0)";

        $result = mysql_query($sql_insert);

    }

}