php同时mysql获取数组，一次更新每10个结果，

Question

我尝试使用 while mysql fetch array 从表中获取所有数据，然后更新。我使用我的代码来做到这一点，并且它工作正常，但一一对应。我需要同时更新每 10 个结果，然后更新其他 10 个结果，直到结束。

我的代码是

$get_urls = mysql_query("select * from urls where (status = 'active') ORDER BY number ASC");
    while($show_url = mysql_fetch_array($get_urls, MYSQL_NUM)) {
    $urlid = $show_url['0'];

    $edit_urls = "UPDATE urls SET online = 'yes' WHERE urlid = '$urlid'";
    mysql_query($edit_urls);

    }
    mysql_free_result($get_urls);

Answer 1

您可以使用array和implode来实现这一点

$array = array();
$get_urls = mysql_query("select * from urls where (status = 'active') ORDER BY number ASC");
    while($show_url = mysql_fetch_array($get_urls, MYSQL_NUM))
       $array[] = $show_url['0'];

$edit_urls = "UPDATE urls SET online = 'yes' WHERE urlid IN (".implode(',',$array).")";
    mysql_query($edit_urls);