for ($i = 0; $arr[i]; ++$i)
$sql = "insert into table(name, webadd) values($arr[2][$i], $arr[1][$i])";
mysql_query($sql);
}
$sql = "insert into table(name, webadd) values($arr[2][$i], $arr[1][$i])";
mysql_query($sql);
}
for ($i = 0; $arr[i]; ++$i)
$sql = "insert into table(sitename, siteurl) values($arr[2][$i], $arr[1][$i])";
mysql_query($sql);
}
$sql = "insert into table(sitename, siteurl) values ('$v', '{$arr[1][$i]}')";
...
}
$data = file_get_contents('book.htm');
preg_match_all('|<A HREF="(.*?)".*?>(.*?)</A>|i', $data, $arr);for ($i = 0;$i < sizeof($arr[1]);$i++)
{
$sql = "insert into table(name, url) values ('{$arr[2][$i]}', '{$arr[1][$i]}')";
//...
}
?>