I Need a Batch Import Script

[rich06]

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