Back of the envelope PHP script to import CSV for Rohan.

csv_import.php

#!/usr/bin/php

/**
* Imports a CSV file into a database.
*/
    $file = $_ARGV[0];
    $handle = fopen($file,"r");
    $key = 0;
    
    $query = "
            INSERT INTO
             `firstName`,
             `lastName`,
              `awardCategory`,
              `tvOrFilmShow`,
              `awardShow`,
              `awardYear`,
              `awardReceived`,
              `id`,
                (
                   %s,     
                )
            ");
    
    
    // Loop through the csv file and insert into database.
    do {
        if ($data[0]) {
            $data = array_map($data, 'mysqli_real_escape_string');
            $data[] = $key;
            $query_values = implode(',', $data);
            mysql_query(sprintf($query, $query_values);
            $key++;
        }
    } while ($data = fgetcsv($handle,1000,",","'"));