Here's around er... $2.15 worth of PHP code that should get you started...
PHP Code:
<?
$sites = file('/path/to/my/text/file.txt');
if (is_array($sites)) {
foreach ($sites as $site) {
$bits = explode('|',$site);
$sql = 'insert into mytable (title,url,description,other_shit) ';
if (is_array($bits)) {
mysql_query($sql."('{$bits[0]}','{$bits[1]}','{$bits[2]}','{$bits[3]}')") or die('whatever');
}
}
}
?>
hth
rich