Not entirely sure what you mean and even more unsure of your command. However I happened to do something similar to what I think you are talking about and made a function to do it, here it is:
Note: You must have an active connection to your database for this to work.
<?php
//$file = The name of the file you want to parse
//$separator = the argument for the end of each element, I used a comma (CSV file)
//$table = your database table
//$field = the field in the table you want to populate
function addfiletotable($file, $separator, $table, $field) {
$fd = fopen("$file", "r"); //opens the file for reading r = read w = write
$contents = fread ($fd, filesize ("$file"));//read the file based on the file's size
fclose ($fd);//close the file
$contents = trim ($contents);//trims any whitespace off the front and back
$exploded = explode("$separator", $contents);//blasts the data into elements based on your separator
$num_elements = count($exploded);//counts the number of elements
for ($i = 0; $i < $num_elements; $i++) { //for each element throw it into the database
$result = "INSERT INTO $table ($field) VALUES ('$exploded[$i]')";
mysql_query($result);
}
}
?>
