插入只做第一行

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);    }}